Disable adding a new tab/worksheet plus button

Hello, I created a floating form and, on this form, I have a button to create a new tab/worksheet from a hidden tab. How can I disable the "+" button to create a new tab/worksheet so the user has to use my button?

Thanks,

If you protect the structure of the workbook Review/Protect Workbook, the user will not be able to add a new sheet. On the other hand, you, in code, will have to programmatically remove the protection, insert a sheet from the "template" and put the workbook structure protection back on.

Artik

Ok thanks all, I'll give the protect/unprotect a try....

Ok I protected the workbook and am using the lock unlock to create the tab which works great BUT it took away the delete so I added a delete button to my form and use the DeleteActiveWorksheet sub which it works great as well.
The issue I have with the delete is I don't want it to never be able to delete a tab called "INFO" and a tab called "MAIN". how can I do that?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Open Visual Basic for Applications (VBA) by pressing Alt+F11.
In the Project Explorer window, find your project and expand it.
Find the "ThisWorkbook" object (or whatever object you have VBA code in).
Double-click an object to open the code editor for that object.
Paste the following code into the code editor:
Private Sub Workbook_Open()
Application.CommandBars("Worksheet Menu Bar").Controls("Sheet Tabs").Enabled = False
End Sub
This code will run every time the workbook is opened and disable the New Tab/Sheet Plus button.
Save your changes and close the code editor.