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

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

on workbook open in Excel 95
 

That works great!

Thank you very much.

Dave Boone