How2 set a shared workbook to always open a certain window size?

  • Thread starter Thread starter Bob W
  • Start date Start date
B

Bob W

Is there a way to force a shared workbook to always open in a smallish size,
window ie, maybe 6" square, for all users?

The idea is to use a hyperlink on the primary worksheet to display a lookup
table in a second worksheet (like a popup help window) without completely
blotting out the primary worksheet.
 
A worksheet open event macro can initialize your windows so they always gives
you the same view.

Private Sub Workbook_Open()
Application.WindowState = xlNormal
Application.Width = 522
Application.Height = 354
End Sub
 
Back
Top