pcc
Well-known Member
- Joined
- Jan 21, 2003
- Messages
- 1,353
I have a workbook that I open up from the Public Folders of my company's Outlook system (by double-clicking it in Outlook itself). When it opens, the window is not maximised. To fix this, I put the following code into the ThisWorkBook module
It opens up maximised, but then after an instant, it goes into a non-maximised state again. If I save the file to a local drive, and open it from there, it works fine.
Anyone have any ideas why this might be happening?
Thanks for all suggestions
Code:
Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized
End Sub
It opens up maximised, but then after an instant, it goes into a non-maximised state again. If I save the file to a local drive, and open it from there, it works fine.
Anyone have any ideas why this might be happening?
Thanks for all suggestions