Be the first user to complete this post
|
Add to List |
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:
- VBA-Excel: Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel.
- Excel-VBA : Send a Simple Mail From MS Outlook Using Excel
- VBA-Excel: Copy/Paste data - Copy the data from a call and paste it to another cell
- VBA-Excel: Add/Insert a Image/Picture in Word Document
- Introduction to Excel WorkBook