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. |
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. |
All times are GMT +1. The time now is 06:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com