| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Locking format
I have a data entry form. I have unlocked the data entry columns, and
protected the sheet. However, users do a fair amount of copy/paste. This messes up the format. I have written code to re-format that data entry form, but I think I must be missing something. Is there a way to protect the format from copy/paste activity? Thanks, Terry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
| Locking a cell's format, but not value | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
