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 Protect the structure of the workbook

In xl2003 menus:

tools|protection|Protect workbook
make sure structure is checked.

AG wrote:

Hi Guys,

I have a template that contains multiple interlinked Worksheets and
several macros inside the sheets. I do not want my users to delete any
worksheet by mistake. Is there a way by which I can protect the
structure of my workbook.

Thanks for the help.

- AG


--

Dave Peterson