Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Number Format Only
I want to protect number format only, while allowing the user to
change the contents of the cells. We have a workbook used by around (I'm told) 25,000 people, with many more to come, which is formatted as text. Users paste numbers into it, and it must preserve leading zeros, and must not convert to exponential notation. But users often paste from other formatted sources such as email, which converts the cell to General number format, losing leading zeros and converting to exponential notation. Worksheet protection doesn't seem to allow editing locked cell contents even with all the restrictions turned off, and of course worksheet protection doesn't apply at all to unlocked cells. I thought about using the Worksheet Change event to trap all pastes and enter them as text, but by the time that Event is triggered, the damage is already done and I don't know if there were leading zeros or how many. Thanks for any suggestions. Thanks, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect cell format | Excel Discussion (Misc queries) | |||
Protect Excel Format Only | Excel Discussion (Misc queries) | |||
Protect Number Format Only | Excel Discussion (Misc queries) | |||
Protect Format OF Worksheet | Excel Worksheet Functions | |||
Number format based on number format of another cell in another workbook | Excel Programming |