| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent Copying Data
Have you tried using cell locking and protection to stop users from
destroying your conditional formatting, this would still allow then the convenience of being able to paste data into the cells. There's a short tutorial in the Excel section on my website that might help. HTH Neil www.nwarwick.co.uk "Chrisp" wrote: Is there a way to prevent users from copying data within a worksheet while still leaving cells open for entry. My problem is they are copying data into cells that when the data is pasted, it wipes out the conditional formatting. Any ideas? -- Chrisp ------------------------------------------------------------------------ Chrisp's Profile: http://www.excelforum.com/member.php...fo&userid=6365 View this thread: http://www.excelforum.com/showthread...hreadid=526229 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Copying Filtered Data | Excel Discussion (Misc queries) | |||
| Identify end of data in worksheet, prevent overshoot | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| copying data from Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
Threaded Mode
