To prevent a user from deleting and renaming a sheet in a workbook

  • Thread starter Thread starter Subodh
  • Start date Start date
S

Subodh

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.
 
Is it ok to stop them from moving and inserting sheets?

If yes, then you could protect the workbook's structure:
Tools|Protection|protect workbook
(in xl2003 menus)
 
Back
Top