View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Expand/Collapse Grouped Data in Protected Worksheet

What do you mean by (auto_open/workbook_open??)

Workbook_Open is an Application 'event'.
May not always work, especially if the file is corrupt, because the
Application controls its functionality! The Application usually
disables events in corrupt files as well as for any other reason it
deems fit to do so during runtime.

Auto_Open is an AutoRunMacro 'procedure'.
This will pretty much always work even though it's also controlled by
the Application because procedures are managed differently than how
events are managed!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion