| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent / Disable Worksheet Copy or Move
Tools, Protection, Protect Workbook, select at least structure.
-- Regards, Tom Ogilvy "Peter Noneley" wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent / Disable Worksheet Copy or Move
Tom,
Thanks for the suggestion, but I don't want to restrict the worksheet in any way, so I would prefer to avoid protecting the workbook. Peter Tom Ogilvy wrote: Tools, Protection, Protect Workbook, select at least structure. -- Regards, Tom Ogilvy "Peter Noneley" wrote in message oups.com... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent / Disable Worksheet Copy or Move
How does that restrict the worksheet beyond the stated move or copy.
-- Regards, Tom Ogilvy "Peter Noneley" wrote in message oups.com... Tom, Thanks for the suggestion, but I don't want to restrict the worksheet in any way, so I would prefer to avoid protecting the workbook. Peter Tom Ogilvy wrote: Tools, Protection, Protect Workbook, select at least structure. -- Regards, Tom Ogilvy "Peter Noneley" wrote in message oups.com... 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 |
| Reply |
| 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 | |||
Linear Mode
