View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Groups and Protected Worksheets - know if protected

I'm confused.

If the sheet was protected, then it was protected to allow you to use the
Outlining feature on that protected sheet.

If the sheet was not protected, then it didn't do anything special--because you
didn't need anything special done to the sheet.

Isn't that what you wanted?

mjones wrote:

<<snipped

Hi Dave, Yes, that is correct. The code is good, but should not
change whether the worksheets are protected or not when the file is
opened. I think you need to finish the code, right?

DaddyO, This code is necessary when outline (groups) are used because
what you say would normally work except with groups.

Thanks,

Michele


--

Dave Peterson