excel training program - Un-protecting worksheet

Resolved · Low Priority · Version Standard

Mon 17 Dec 2007, 12:12 Delegate Alexandra said...

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?

Mon 17 Dec 2007, 12:49 Trainer Sandy said...

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

Tue 18 Dec 2007, 23:27 Trainer Rajeev said...

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

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)

In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips