Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Q] Protecting a formating against Copy Paste
Hi everyone
I have a tricky problem. I need to protect the formating of a spreadsheet against the copy paste, but on the other side I want to allow the user to paste values. I find two possible solutions, but I am not sure they are feasable First solution, having a VBA code that "forces" a copy paste by value when the user is only pasting normally. Is that kind of code doable in Excel? Second solution, protecting the spreadsheet partially, such that the user can still past things in the sheet but can not affect the conditional formating. I also need the user to be able to insert or delete rows. If you see a way to do that in Excel or VBA, I would be really interested! Thanks in advance Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting a file from Copy/Paste | Excel Discussion (Misc queries) | |||
protecting cells against editing by copy/paste actions | Setting up and Configuration of Excel | |||
protecting ceels to copy -paste action | Excel Worksheet Functions | |||
protecting ceels to copy -paste action | New Users to Excel | |||
protecting ceels to copy -paste action | Excel Discussion (Misc queries) |