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

[nuttyengineer]

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

[MarvinP]

Hi,

How about another solution with this code.

Please Login or Register  to view this content.

[nuttyengineer]

Hello MarvinP,

You did it again! Thank you!

After a few minor mods to the code above I can now move Summary sheet around in workbook without it affecting the code running.

Thank you very much for your time and help.

Nutty