Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Un-protecting worksheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training program - Un-protecting worksheet

Resolved · Low Priority · Version Standard

Reply Mon 17 Dec 2007, 12:12Delegate 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?

For upcoming training course dates see: Pricing & availability

Reply Mon 17 Dec 2007, 12:49Trainer 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

Reply Tue 18 Dec 2007, 23:27Trainer 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

Excel articles

· How Excel Can Help You See Into Your Business's Future
· Employing Cell References in Excel
· Tracking In Excel 2003
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Break The Mystery Of Code With Excel Macros

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips