Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code to prevent users from adding new worksheets
i want to prevent users from adding new or blank worksheets on a form, but i
cannot get the code below to work: Private Sub Workbook_NewSheet(ByVal Sh As Object) If Not BlockInsertSheet Then Exit Sub With Application .DisplayAlerts = False .ScreenUpdating = False End With Sh.Delete With Application .DisplayAlerts = True .ScreenUpdating = True End With End Sub i have te code in the Microsoft Excel Objects, This Workbook module but i cannot get it to work. what's missing? jat |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code to prevent users from adding new worksheets
Hi,
Try this. Double click 'ThisWorkbook' and paste this in on the right Private Sub Workbook_NewSheet(ByVal Sh As Object) Application.DisplayAlerts = False MsgBox "No new sheets thank you" Sh.Delete Application.DisplayAlerts = True End Sub Mike "jat" wrote: i want to prevent users from adding new or blank worksheets on a form, but i cannot get the code below to work: Private Sub Workbook_NewSheet(ByVal Sh As Object) If Not BlockInsertSheet Then Exit Sub With Application .DisplayAlerts = False .ScreenUpdating = False End With Sh.Delete With Application .DisplayAlerts = True .ScreenUpdating = True End With End Sub i have te code in the Microsoft Excel Objects, This Workbook module but i cannot get it to work. what's missing? jat |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code to prevent users from adding new worksheets
You can do that by password protecting the workbook,
Regards, Alan. "jat" wrote in message ... i want to prevent users from adding new or blank worksheets on a form, but i cannot get the code below to work: Private Sub Workbook_NewSheet(ByVal Sh As Object) If Not BlockInsertSheet Then Exit Sub With Application .DisplayAlerts = False .ScreenUpdating = False End With Sh.Delete With Application .DisplayAlerts = True .ScreenUpdating = True End With End Sub i have te code in the Microsoft Excel Objects, This Workbook module but i cannot get it to work. what's missing? jat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent users from adding rows in Excel 2000 | Excel Discussion (Misc queries) | |||
Prevent wandering users | Excel Discussion (Misc queries) | |||
Prevent users from copying worksheets | Excel Discussion (Misc queries) | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |