Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to unable the user to add more sheets to a workboo
Same question
is it possible to disable to deletion of worksheet in a workbook ? Thanks for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to unable the user to add more sheets to a workboo
Bonjour François,
If you password protect your workbook, then you can't add or delete a worksheet. Hope this was helpful Denys "François" wrote: Same question is it possible to disable to deletion of worksheet in a workbook ? Thanks for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to unable the user to add more sheets to a workboo
Bit kludgy, but seems to work
Private Sub Workbook_NewSheet(ByVal Sh As Object) Application.DisplayAlerts = False Sh.Delete Application.DisplayAlerts = True End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips "François" wrote in message ... Same question is it possible to disable to deletion of worksheet in a workbook ? Thanks for your help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
is it possible to unable the user to add more sheets to a workboo
Using menu Goto
Tools - Protection - Protect Workbook Make sure Structure is checked. Programatically ThisWorkbook.Protect Structu=True Regards, Jayant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to select sheets when maximized | Excel Discussion (Misc queries) | |||
How to keep font color when referencing Sheets in the same workboo | Excel Worksheet Functions | |||
how do i link one sheet to another sheets cell of the same workboo | Excel Discussion (Misc queries) | |||
Can columns be hidden accross multiple sheets in an Excel workboo | Excel Worksheet Functions | |||
Unable to add user-defined data types to a collection | Excel Programming |