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
Bookmarks