The UNPROTECT option

G

Guest

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
(e-mail address removed)> wrote in message
news:[email protected]...
 
G

Guest

PERFECT!!!!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top