| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent / Disable Worksheet Copy or Move
Hi all,
Even after (or because of) a few glasses of red wine, I cannot figure out how to do this... I want to prevent the user from using [Worksheet,Copy] or [Worksheet,Move] I don't want to remove the commands from the menu, in fact I don't want to fiddle with the menus at all. I just want to catch the commands and make them null. If there was an event such as [BeforeWorksheetCopy] life would be easy, but I dont know of such a command, so I am relying on the group! A bottle of red to whoever provides the answer that works... Thanks Peter Noneley cardiff Wales UK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i disable/enable "Worksheet Move or copy" option? | Excel Worksheet Functions | |||
| Prevent copy of formulas on a worksheet | Excel Discussion (Misc queries) | |||
| How to disable copy of protected excel worksheet? | Excel Discussion (Misc queries) | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| Prevent changing size when copy&paste into another Excel Worksheet | Excel Worksheet Functions | |||
Threaded Mode
