Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The UNPROTECT option
The UNPROCTECT option is not available on a protected worksheet. How then
will I unprotect it? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
Second option button disappears when I make another column | Excel Worksheet Functions | |||
Filter option | Excel Discussion (Misc queries) | |||
No Save As option | Excel Discussion (Misc queries) | |||
Unable to unlock protection, Option Grayed out | Excel Worksheet Functions |