Open An Excel File Maximised Using Hyperlink

[kevsim]

I tried the below code, this is OK when the Excel file opens in Excel, it opens maximised.
Using the command button with the hyperlink in Access, the excel file opens about half screen size.
I need the Excel file to open maximised.

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized
Application.WindowState = xlMaximized
End Sub

I would appreciate some assistance.
kevsim

 

[bat17]

I think that you will need to put the code in the Workbook_Open event in excel.

Peter

 

[kevsim]

Peter,
Thanks for the info.
That is where the code is.
kevsim

 

[bat17]

Oops I did not read your post well enough!

I have tried it on my pc, A97/XL200 on W2K and it works fine, XL opens maximised.

It may be worth asking in the XL forum as well in case it is something in XL rather than Access.

Peter