Excel-VBA : Prevent Adding New Worksheet

Many a times you need a scenario where you dont want user to add new worksheets in you Excel work book.

Its quite easy to do.

Steps:

• Go to VBA Editor
• Expand your VBA Project
• Double Click ThisWorkBook

• Now select the "Workbook" from the first drop down on the right

• Select the NewSheet from the second drop down on the right

• Now you will see the function Private Sub Workbook_NewSheet(ByVal Sh As Object).

• Add the following code in the function.

Application.DisplayAlerts = False

ActiveSheet.Delete

MsgBox "Sorry, Adding new Sheet is not allowed"

And thats it you are done. Lets test our program.

Go to excel and try adding a new worksheet.

Also Read:

1. Excel-VBA : Prevent Changing the WorkSheet Name
2. VBA-Excel: Writing Text to Word document
3. VBA-Excel: Create or Add Worksheets at the Run time.
4. VBA-Excel: Open a Excel WorkBook
5. VBA-Excel: Launch Mozilla Firefox using Microsoft Excel.