Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protect Cell Formatting
I have problems with users wanting to cut and paste data in the cells. How do
I protect a worksheet to keep someone from "cutting" an unlocked cell and pasting it in another "unlocked" region. They destroy the formatting such as borders, backcolors, etc. and make quite a mess. I would like to retain the ability to copy the contents of the cell but not the formatting. |
#2
|
|||
|
|||
Show them about "Paste special". when you right click you'll find that
option righ below Paste. So select paste special then select Values. Another way to do is it trough VBA by recreating the right click menu. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel how do I protect the format of a cell but let the user c. | Excel Discussion (Misc queries) | |||
Conditional Formatting if any value in the cell | Excel Worksheet Functions | |||
Formatting dates in the future | Excel Worksheet Functions | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
Protect Cell if value <> 0 OR blank? | Excel Worksheet Functions |