Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared workbook file size becoming very large | Excel Discussion (Misc queries) | |||
How to open Excel workbook in full size window | Excel Discussion (Misc queries) | |||
Shared Workbook inexplicably grows in size | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
I can't adjust the window size of an active workbook. | Excel Discussion (Misc queries) |