View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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