Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to prevent a user from adding worksheets to a particular
workbook. The code I am using (see below) doesn't work; I don't get any error messages. Any suggesions on what I am doing wrong? Private Sub Workbook_NewSheet(ByVal Sh As Object) Application.DisplayAlerts = False MsgBox "New sheets may not be added. " & _ "Sheet will be deleted" Sh.Delete Application.DisplayAlerts = True End Sub Thanks...Paige |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent formula from changing when adding in cells | Excel Discussion (Misc queries) | |||
code to prevent users from adding new worksheets | Excel Worksheet Functions | |||
Prevent adding rows | Excel Programming | |||
How to prevent anyone from viewing the code | Excel Programming | |||
Adding code to worksheets | Excel Programming |