Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I understand how to lock cells; however, I have changed a format and would
like for some of the cells that were locked to become unlocked when the sheet is protected. How do I unlock these locked cells. Sincerely, robin |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In 2003, you have to go to TOOLS and then PROTECTION to globally turn on or
off the capability, and then go the FORMAT CELLS and the PROTECTION tab to deal with the settings of individual cells. "Robin" wrote: I understand how to lock cells; however, I have changed a format and would like for some of the cells that were locked to become unlocked when the sheet is protected. How do I unlock these locked cells. Sincerely, robin |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Thank you. That was helpful. It is if I leave it withouththe check in it when they are unlocked and with the check in the box when they are locked. Robin "Peter" wrote: In 2003, you have to go to TOOLS and then PROTECTION to globally turn on or off the capability, and then go the FORMAT CELLS and the PROTECTION tab to deal with the settings of individual cells. "Robin" wrote: I understand how to lock cells; however, I have changed a format and would like for some of the cells that were locked to become unlocked when the sheet is protected. How do I unlock these locked cells. Sincerely, robin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I 'unlock' it when it says my document is locked? | Excel Discussion (Misc queries) | |||
Unlock, locked spreadsheet | Excel Discussion (Misc queries) | |||
worksheet is locked on highlight how do I unlock it | Excel Worksheet Functions | |||
some keys locked on keyboard. How do I unlock it? | Excel Discussion (Misc queries) | |||
Excel file locked for editing by 'my name' ! How do I unlock? | Excel Discussion (Misc queries) |