Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I lock the format but still allow a user to input values into a cell?
I have cells that are unlocked to allow for operator entry but if the operator copies and pastes from another spreadsheet, the format I've set up changes to whatever the copied and pasted cell had. thanks Irie! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
row locking, instead of file locking? | Excel Discussion (Misc queries) | |||
Locking a row | New Users to Excel | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking format | Excel Worksheet Functions | |||
Locking a cell's format, but not value | Excel Discussion (Misc queries) |