Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To prevent a user from deleting and renaming a sheet in a workbook
My code takes the number of sheets and the sheets name as arguments.
and i have fixed that. I want to prevent the user from deleting any sheet or renaming them How can i do that? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
To prevent a user from deleting and renaming a sheet in a workbook
Is it ok to stop them from moving and inserting sheets?
If yes, then you could protect the workbook's structu Tools|Protection|protect workbook (in xl2003 menus) Subodh wrote: My code takes the number of sheets and the sheets name as arguments. and i have fixed that. I want to prevent the user from deleting any sheet or renaming them How can i do that? Thanks in advance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
To prevent a user from deleting and renaming a sheet in a workbook
You should always use Sheet CodeNames when working with sheets.
http://www.ozgrid.com/VBA/excel-vba-sheet-names.htm -- Regards Dave Hawley www.ozgrid.com "Dave Peterson" wrote in message ... Is it ok to stop them from moving and inserting sheets? If yes, then you could protect the workbook's structu Tools|Protection|protect workbook (in xl2003 menus) Subodh wrote: My code takes the number of sheets and the sheets name as arguments. and i have fixed that. I want to prevent the user from deleting any sheet or renaming them How can i do that? Thanks in advance. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
To prevent a user from deleting and renaming a sheet in a workbook
That's not always possible.
"ozgrid.com" wrote: You should always use Sheet CodeNames when working with sheets. http://www.ozgrid.com/VBA/excel-vba-sheet-names.htm -- Regards Dave Hawley www.ozgrid.com "Dave Peterson" wrote in message ... Is it ok to stop them from moving and inserting sheets? If yes, then you could protect the workbook's structu Tools|Protection|protect workbook (in xl2003 menus) Subodh wrote: My code takes the number of sheets and the sheets name as arguments. and i have fixed that. I want to prevent the user from deleting any sheet or renaming them How can i do that? Thanks in advance. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent a user from adding any sheet in a workbook | Excel Programming | |||
prevent user from deleting a tab prevent running macro from menu | Excel Programming | |||
Prevent someone from renaming a workbook | Excel Programming | |||
Prevent user deleting an XLS file | Excel Programming | |||
Excel 97 - Prevent Renaming/Deleting Protected Worksheet | Excel Programming |