Alexandra has attended:
Excel Intermediate course
Excel Advanced course
Un-protecting worksheet
I have protected part of a worksheet by going to tools and clicking on protect worksheet, (I did not submit a password) - but the 'unprotect' option is unavailable and am now unable to work on the document. How can I resolve this?
RE: Un-protecting worksheet
Hi Alexandra
If you protected the whole of your worksheet via Tools menu, Protection, Protect Sheet without a password, then you should be able to repeat the steps and select UnProtect Sheet.
If you have anymore problems please get in touch.
Regards
Sandy
RE: Un-protecting worksheet
Dear Alexandra
One of the main reason why you normally can't unprotect the sheet is if you have double-clicked on the Unlocked cell and teh cursor is blonking on the cell.
Excel assumes that you are currently working on that cell and therefore greys out the unprotect sheet.
Please ensure that you are not double clicking on the unlocked cells or your cursor isn't blinking on the formula bar!!
That should hopefully resolve the problem.
Please let me know if it works or not!! IF NOT then there may be more complicated reason if this dopesn't help!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
