Forcing Workbook to Maximize

[Llobid]

I have a small annoyance that I hope someone can help with. I hav
linked an Excel file from an Access database form. The link work
fine...opens the spreadsheet as it should. However, when I open th
spreadsheet using the link, the file opens maximized...but th
worksheet itself doesn't. In other words, the worksheet must b
maximized in order to see the tabs at the bottom.

I have tried to go directly to the file, open, maximize, then resave
but to no avail. I have also tried to relink after doing th
above...nada. I know there must be an option somewhere that will forc
this thing to open maximized, but I cannot find it.

I am using Excel 2003, but will also be used on Excel 2000.

Thanks for any help you can give

 

[Dave Peterson]

Can you have a macro in that excel workbook that maximizes the windows?

Option Explicit
Sub auto_open()
Application.WindowState = xlMaximized
ThisWorkbook.Windows(1).WindowState = xlMaximized
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm