| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do not allow Copy/Paste Functionality in a Protected Sheet
Hi,
I have a Protected worksheet having 4 columns whe 1. Column A and B is Un-Protected and 2. Column C and D is Protected with Formulae. However, in column A, I have "MM/DD/YY" Format and in Column B I have a Drop-Down list. I don't want to mess up my column A Format, since people can copy/paste cells from column B or a different Format from another sheet into cells in the Column A. Please help me out to de-activate the Copy/Paste or Cut/Paste function so that only Manual entry is possible in my Protected Sheet. Your help will be greatly appreciated. Thanks in advance, Prashanth KR. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to disable copy and paste function in a protected sheet | Setting up and Configuration of Excel | |||
| how can i turn on the copy/paste functionality in excel 2000 | Excel Discussion (Misc queries) | |||
| allow me to copy and paste in a protected worksheet | New Users to Excel | |||
| How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) | |||
| How to restore right click functionality for copy and paste? | Excel Discussion (Misc queries) | |||
Threaded Mode
