| 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
Did you try going to 'Tools' choose 'Options' then choose the 'Edit' tab?
then unclick what you don't want anyone to be able to do on your spreadsheet. Hope this helps "Paulo Costa (Live)" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to prevent Cut&Paste to change style and data validation on pr
Thanks Barb, but this doens't sort out the issue.
"Barb H" wrote in message ... Did you try going to 'Tools' choose 'Options' then choose the 'Edit' tab? then unclick what you don't want anyone to be able to do on your spreadsheet. Hope this helps "Paulo Costa (Live)" wrote: 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 to prevent Cut&Paste to change style and data validation on protected sheet | Excel Discussion (Misc queries) | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| How to prevent warning messages on protected work sheet. | Excel Worksheet Functions | |||
| Apply Validation on a protected sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
