Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to save a desired window size but hv window comeup fullsz by d
say I am creating a small list, I resize the window for that list and when I
save it, I want the desired window size to save for that purpose. However, when I open a new empty celled window, I want it to open full size by default since I do not know how much space i'll need for the next project. Is it possible to have excel save a desired windowsize along with any one given project but still open full size by default, can someone help me on this one, thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to save a desired window size but hv window comeup fullsz by d
Here is an alternative. Say we want Excel to open full size, but set the
Zoom to the useful area in the small table. Include this small mcro in the workbook code area: Private Sub Workbook_Open() ActiveSheet.UsedRange.Select ActiveWindow.Zoom = True End Sub -- Gary''s Student - gsnu200769 "smjm1982" wrote: say I am creating a small list, I resize the window for that list and when I save it, I want the desired window size to save for that purpose. However, when I open a new empty celled window, I want it to open full size by default since I do not know how much space i'll need for the next project. Is it possible to have excel save a desired windowsize along with any one given project but still open full size by default, can someone help me on this one, thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
Excel 2002; how to reduce the size of the save dialogue window? | Excel Discussion (Misc queries) | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Save As Window Size | Excel Discussion (Misc queries) |