Re: Prevent / Disable Worksheet Copy or Move

Tech-Archive recommends: Fix windows errors by optimizing your registry

Tools, Protection, Protect Workbook, select at least structure.

--
Regards,
Tom Ogilvy


"Peter Noneley" <xlfdic@xxxxxxxxxxx> wrote in message
news:1126474980.659281.274370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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 [Work***,Copy] or
> [Work***,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
>


.

Quantcast