Re: Prevent / Disable Worksheet Copy or Move

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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" <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 [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
> >

.



Relevant Pages

  • Re: Lock and Unlock Cells
    ... Try it in a new workbook. ... "Peter" wrote in message ... > "Tom Ogilvy" wrote: ... Dim aws as Worksheet ...
    (microsoft.public.excel.programming)
  • Re: Remove Macro
    ... No. Protecting the workbook is done in Tools=>Protection=>Protect Workbook ... Protecting the project is done in the VBE under Tools=>VBA Project Name ... Tom Ogilvy ... "Hargrove" wrote in message ...
    (microsoft.public.excel.programming)
  • Re: Finding Names associated with a cell
    ... Tom Ogilvy ... "Peter" wrote in message ... > I have to loop through all names associated with the workbook and look for ...
    (microsoft.public.excel.programming)
  • Re: How to enable macro
    ... close the workbook, then reopen it and don't choose to disable macros. ... Tom Ogilvy ... "Peter" wrote in message ...
    (microsoft.public.excel.programming)
  • Re: Linking Worksheets in a Workbook
    ... protecting a workbook's ... -Moving, deleting, hiding, or changing the names of worksheets. ... -Inserting new worksheets or chart sheets. ... -Moving or copying worksheets to another workbook. ...
    (microsoft.public.access.externaldata)