Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent a user from adding any sheet in a workbook
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to prevent adding sheet in a workbook. | Excel Programming | |||
Prevent user from saving workbook | Excel Discussion (Misc queries) | |||
prevent user from selecting and changing a sheet | Excel Programming | |||
prevent user to rename sheet | Excel Programming | |||
How to Prevent User from Unhiding Sheet | Excel Programming |