| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect formatting
I have a sheet with cells containing conditional formatting. The user of the
sheet is supposed to paste data. If data is pasted normally (Ctrl+V) then formatting is gone. If paste special values is used then it works fine. However I need to ensure that paste special values is used. Is it possible to lock the formatting of cells in som way? Any other ideas how to solve this problem? Thank you The Doctor |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to protect formatting
And I using Excel 2003 version.
"Dr. Schwartz" wrote: I have a sheet with cells containing conditional formatting. The user of the sheet is supposed to paste data. If data is pasted normally (Ctrl+V) then formatting is gone. If paste special values is used then it works fine. However I need to ensure that paste special values is used. Is it possible to lock the formatting of cells in som way? Any other ideas how to solve this problem? Thank you The Doctor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect the formatting | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| How do I protect formatting only? | Excel Discussion (Misc queries) | |||
| Protect conditonal formatting | Excel Discussion (Misc queries) | |||
| protect formatting | Excel Discussion (Misc queries) | |||
![Dr. Schwartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
