View Single Post
  #2  
Old March 18th, 2004, 07:56 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default Protecting selected Worksheets at Once

Hi
you can only protect one worksheet. For more you'll need a macro which
iterates through your worksheets

--
Regards
Frank Kabel
Frankfurt, Germany


Gunjani wrote:
Since 'Protecting Workbook' does not allow the options as 'Protect
Worksheets' how may I select several worksheets (grouping them or
otherwise) and protect them(obviously with same elements)?

Also how can I identify which worksheets I have selected to group?