setting excel visually

[AmyTaylor]

Hi all, is is possible, thru VBA to automatically set an Excel workbook to open at size 70% (for example), and to automatically open as full screen, and then when the particular excel workbook closes to reset to 100% and switch off full screen ??

Many thanks for any help
Amy xx

[Bob Phillips]

Hi Amy,

Like so

activewindow.Zoom=70

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AmyTaylor" <[email protected]> wrote
in message news:[email protected]...
>
> Hi all, is is possible, thru VBA to automatically set an Excel workbook
> to open at size 70% (for example), and to automatically open as full
> screen, and then when the particular excel workbook closes to reset to
> 100% and switch off full screen ??
>
> Many thanks for any help
> Amy xx
>
>
> --
> AmyTaylor
> ------------------------------------------------------------------------
> AmyTaylor's Profile:
http://www.excelforum.com/member.php...o&userid=20970
> View this thread: http://www.excelforum.com/showthread...hreadid=400757
>

[AmyTaylor]

Thanks Bob, you are great !

xx