The UNPROTECT option

  • Thread starter Unprotect option inactive
  • Start date
U

Unprotect option inactive

The UNPROCTECT option is not available on a protected worksheet. How then
will I unprotect it?
 
P

PCLIVE

If your cursor is active in the formula bar, then the Protect options will
not be available. Try pressing Enter and then attempt to access the options
again.
Also, if the workbook is shared, these options will not be available.

If it is ok to remove sharing from the document, go to Tools-Share Workbook.
On the 'Editing' tab, uncheck the box that allows changes by more than one
user.

HTH,
Paul

"Unprotect option inactive" <Unprotect option
[email protected]> wrote in message
news:[email protected]...
 
U

Unprotect option inactive

PERFECT!!!!

The workbook was shared. Thank you so much for your expertise and going a
step further with the information.
 
Top