Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting unlocked cells on protected sheet
After protecting my sheet, I can enter data into unlocked cells, but I
cannot change the formatting for those same cells. (I need to be able to adjust the decimal places.) Is it possible to protect a sheet, but still allow formatting to be changed on unlocked cells? Note: I have considered writing VBA code that unprotected the sheet, updated the cell format, then re-protected the sheet, but this won't work because there is no way for the VBA code to know the password originally used to protect the sheet. TIA! Lee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting unlocked cells on protected sheet
If you have xl2002 or later you can.
In earlier versions, there is no support for this. -- Regards, Tom Ogilvy "Lee Schipper" wrote in message ... After protecting my sheet, I can enter data into unlocked cells, but I cannot change the formatting for those same cells. (I need to be able to adjust the decimal places.) Is it possible to protect a sheet, but still allow formatting to be changed on unlocked cells? Note: I have considered writing VBA code that unprotected the sheet, updated the cell format, then re-protected the sheet, but this won't work because there is no way for the VBA code to know the password originally used to protect the sheet. TIA! Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unlocked Cells in Protected Sheet | Excel Worksheet Functions | |||
How can I format unlocked cells when the work sheet is protected | Excel Discussion (Misc queries) | |||
Allowing comments in unlocked cells within protected sheet | Excel Discussion (Misc queries) | |||
allow comments, unlocked cells, protected sheet | Excel Programming | |||
move between unlocked cells on protected sheet | Excel Discussion (Misc queries) |