Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Validated cells from pasting over data
Is there a way of protecting a worksheet so that you cannot paste data into it.
I have a column of data and a validation list to select from short name months Jan-Dec, however some people are pasting in full month names, which means I then have to change them before I can create pivot tables on the data. This can be very time consuming when I am receiving many sheets from various sources, and trying to collate everything together. Many Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |