excel training program - 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

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