How2 set a shared workbook to always open a certain window size?
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. |
How2 set a shared workbook to always open a certain window size?
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. |
All times are GMT +1. The time now is 05:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com