VBA to hide "Insert Worksheet" tab

Question:
Is there a way to hide the "Insert Worksheet" tab in '07? I would like to hide the tab so that users cannot add another worksheet to the workbook. I have tried the standard right click, but Excel will not allow you do that. I also dont want to lose visibility to the other worksheet tabs already created. Thank you in advance.

There are other ways to add sheets, better to prevent by using this code

Please Login or Register  to view this content.

Copy the code
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

If you protect the workbook structure the Insert Worksheet button will not work.

Originally Posted by Randall00

If anyone has any idea, I would still like to know how to hide the tab without hiding all of the others.

Going through the entire process is a bit beyond the scope of this thread. In short, you set the visible property to false (for a group within a tab in the example below) in the XML like this:

Please Login or Register  to view this content.

If you are willing to go 'all in' on learning about the ribbon and subsequent manipulation, I would suggest RDB's library of how-to's as a starting point.

http://www.rondebruin.nl/xmlribbongroups.htm