Workbook window setup

[greg malenky]

Excel 2000 -

I'm creating a spreadsheet program that I want the
windows to open without any of the toolbars, and the
window to be sized to fit the area of the spreadsheet,
which is smaller than the actual computer screen. What
happens though, is when I make the changes in the
workbook, all my other excel spreadsheets open up with
the same window styles. I would like my other workbooks
to open as they did before. Any help?

Thanks,
Greg Malenky

 

[Bob Phillips]

Put the code in the workbook_Activate event, and reset in deactivate.