Results 1 to 3 of 3

How to disable Move or Copy option in menu of one sheet only in workbook

Threaded View

  1. #1
    Registered User
    Join Date
    09-27-2010
    Location
    England
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    20

    Thumbs up How to disable Move or Copy option in menu of one sheet only in workbook

    I have a workbook with a number of sheets. New sheets are added regularly in the second position.

    The first sheet in the workbook is a Summary sheet which needs to stay in its position in the workbook i.e. index 1, first from left. It has VBA code which is used to pull info from the other added sheets but for it to work correctly it needs to stay in this index 1 position and not be moved.

    Requests

    1. I would like to know how to disable Move or Copy option for one sheet only in workbook i.e. the Summary sheet mentioned above.
    If I use Tools > Protection > Protect Sheet, the code on the Summary sheet does not execute correctly.

    2. I would like to be able to Insert, Move or Copy other sheets in the workbook but not allow them to be copied to the index 1 position i.e. not take the position of the Summary sheet


    Any help with this code would be appreciated.
    Thanks
    Last edited by nuttyengineer; 09-02-2011 at 08:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1