Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code so that worksheets cannot be added to workbook
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code so that worksheets cannot be added to workbook
This is awesome!! Works great. Perfect for those workbooks that users are
having to paste data to that is linked to say another workbook or program. Thanks! "FSt1" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code so that worksheets cannot be added to workbook
You could protect the workbook's structure.
But that will prevent new sheets, moving existing sheets, deleting sheets, renaming sheets... In xl2003 menus: tools|protection|protect workbook 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make VBA code usable on all worksheets of a workbook? | Excel Programming | |||
How many total worksheets can be added to a workbook? | Excel Discussion (Misc queries) | |||
HELP = VBA Code To Import Worksheets Into A WorkBook | Excel Programming | |||
Rename worksheets of workbook - Error code | Excel Programming | |||
macro to execute code on all worksheets in workbook | Excel Programming |