Prev: PivotTable 2003 Code is not working
Next: Formula Question
From: Subodh on 6 Apr 2010 11:09
I have an excel workbook in which i don't want the user to add any
sheets.
I tried following code to delete the sheet every time a new sheet is
inserted.
However, Microsoft generates a message and user has to select Delete
key every time
and if the user presses cancel then a sheet is inserted.
How can i automatically make the Delete selection so that user cannot
insert aany sheets.

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Sh.Delete
End Sub
 | 
Pages: 1
Prev: PivotTable 2003 Code is not working
Next: Formula Question