The UNPROTECT option
 

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

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
wrote in message
...
The UNPROCTECT option is not available on a protected worksheet. How then
will I unprotect it?

PERFECT!!!!

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

"Unprotect option inactive" wrote:

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

You're welcome.

Thanks for the feedback.
Paul

"Unprotect option inactive"
wrote in message
...
PERFECT!!!!

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

"Unprotect option inactive" wrote:

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