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

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

--
HTH

Bob Phillips

"greg malenky" wrote in message
...
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