Re: Prevent / Disable Work*** Copy or Move

Tom,

Thanks for the suggestion, but I don't want to restrict the work***
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" <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
> >

.