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.