| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
on workbook open in Excel 95
Hello,
I want to use the Workbook_Open() sub to hide sheets for my excel application. I need it to run in Excel 95 and when I save down this code is deleted and can't be saved in the Workbook code area. How else can I ensure that the sheets are hidden when the workbook is opened? Thanks, Dave |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
on workbook open in Excel 95
Events were added in Excel97, so you can't use Workbook_Open.
Instead, create a normal macro named Auto_Open. This macro will run when the workbook is opened (except when opened via VBA code). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... Hello, I want to use the Workbook_Open() sub to hide sheets for my excel application. I need it to run in Excel 95 and when I save down this code is deleted and can't be saved in the Workbook code area. How else can I ensure that the sheets are hidden when the workbook is opened? Thanks, Dave |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
on workbook open in Excel 95
That works great!
Thank you very much. Dave Boone |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Linear Mode
