New Workbook

J

Jess

When I open a new workbook, or even a current file, the window itself
opens too large for my screen and I have to scale it down. Is there
any way to change the default setting so that I don't have to do
conitnually do this?
 
L

little_creature

You can solve it for example by doing a macro like this:

Private Sub scale_down()

With ActiveWindow
.Width = 882
.Height = 675
End With
End Sub

If saved into personal.xls it sets the workbook window to size of 882*675
pixels.

If you are not familiar with macros you can do it as following:
1.tools>macros>macros>record new macro (where select store macro in personal
macro workbook)
2. Resize the window for size you like and stop the macro recording
3. in order to run the macro on startup do:
window>unhide>personal...
tools>macros>visual basics editor where you will see something like above,
all you need to do is to add the private
Sub MACRONAME()
to
Private Sub MACRONAME()
and save it. (if the excel will say that personal workbook has changed and
whether you want to save changes, say yes)
 
Top