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

"Bob W" wrote:

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.