Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What is the approach I could use to prevent the user from adding new blank
worksheets using the Insert.. Worksheet... function? I've found the Workbook_NewSheet event but this fires after the sheet has been created. I have a command button on the sheet that creates the new sheets for the user by copying a hidden template sheet. This macro does not trigger the NewSheet event. In the Workbook_NewSheet event, I can call the delete method: ActiveWorkbook.Sheets(Sh.Name).Delete but this generates the "Data may exist in sheet(s)... Warning. How do I supress this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
prevent user from deleting a tab prevent running macro from menu | Excel Programming | |||
Prevent user from copying contents of a worksheet | Excel Discussion (Misc queries) | |||
Prevent Inserting rows/columns | Excel Discussion (Misc queries) | |||
Prevent user from inserting sheet via "CTRL-F11" | Excel Programming | |||
How can I prevent Excel 2000 from inserting hyperlinks? | Setting up and Configuration of Excel |