Thread: Code so that worksheets cannot be added to workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default Code so that worksheets cannot be added to workbook
hi
personally i don't know how you can prevent users from adding new sheets but
you can delete them as fast as they are added.

Private Sub Workbook_NewSheet(ByVal Sh As Object)
MsgBox "new sheet are prohibited."
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True
End Sub

regards
FSt1

"D" wrote:

Does anyone know if it is possible to have a code in the background that will
not let users add worksheets to a workbook? If so, how would this be done?
Reply With QuoteReply With Quote