View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Noneley Peter Noneley is offline
external usenet poster
 
Posts: 15
Default 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