Mac Forum / Applications / Excel / June 2006

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)

On 29.6.2006 18:58, in article
1151600281.606474.179670@p79g2000cwp.googlegroups.com, "Jess"
<mcconlog@yahoo.com> wrote: