| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unlock worksheet
How do iunlock a worksheet if the Unprotect Sheet symbol is grayed out?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unlock worksheet
Is the workbook shared?
If it is then un-share it and then unprotect the sheet. Mike "Gordy" wrote: How do iunlock a worksheet if the Unprotect Sheet symbol is grayed out? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unlock worksheet
Yes it is a shared workbook, it is a downloaded workbook as part of a
tutorial lesson. The symbol at the top of the Changes group can be changed from Protect Shared Workbook or Unprotect Shared Worksheet. I have it set at showing Protect Shared Worksheet, so I assume that it may be shared. They Unprotect Sheet is still grayed out and it will not allow me to make changes to the worksheet. "Mike H" wrote: Is the workbook shared? If it is then un-share it and then unprotect the sheet. Mike "Gordy" wrote: How do iunlock a worksheet if the Unprotect Sheet symbol is grayed out? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unlock worksheet
Try,
Tools|Share workbook Remove the checkmark and that should allow you to unprotect. You will of course have to re-share it when you've done what you want to do. Mike "Gordy" wrote: Yes it is a shared workbook, it is a downloaded workbook as part of a tutorial lesson. The symbol at the top of the Changes group can be changed from Protect Shared Workbook or Unprotect Shared Worksheet. I have it set at showing Protect Shared Worksheet, so I assume that it may be shared. They Unprotect Sheet is still grayed out and it will not allow me to make changes to the worksheet. "Mike H" wrote: Is the workbook shared? If it is then un-share it and then unprotect the sheet. Mike "Gordy" wrote: How do iunlock a worksheet if the Unprotect Sheet symbol is grayed out? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unlock VBE | Excel Discussion (Misc queries) | |||
| How to Unlock | New Users to Excel | |||
| worksheet is locked on highlight how do I unlock it | Excel Worksheet Functions | |||
| How do I unlock a protected worksheet | Excel Worksheet Functions | |||
| how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
Hybrid Mode
