| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to prevent Cut&Paste to change style and data validation on protected sheet
Hi
I would like to prevent that pasting to unlocked cells on a protected sheet changes the data validation and style. Is this possible? Thanks, PC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to prevent Cut&Paste to change style and data validation on pr
Maybe you should use PasteSpecial/Values instead of Paste.
-- Regards! Stefi €˛Paulo Costa (Live)€¯ ezt Ć*rta: Hi I would like to prevent that pasting to unlocked cells on a protected sheet changes the data validation and style. Is this possible? Thanks, PC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| How to paste objects in a protected sheet | Excel Discussion (Misc queries) | |||
| How to prevent warning messages on protected work sheet. | Excel Worksheet Functions | |||
| Apply Validation on a protected sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
