| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refresh external data on a protected sheet | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
| How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
![GS[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
