setting excel visually
 

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

Many thanks for any help
Amy x

--
AmyTaylo
-----------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2097
View this thread: http://www.excelforum.com/showthread.php?threadid=40075

setting excel visually
 

Hi Amy,

Like so

activewindow.Zoom=70

--

HTH

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


"AmyTaylor" wrote
in message ...

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

setting excel visually
 

Thanks Bob, you are great !

x

--
AmyTaylo
-----------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2097
View this thread: http://www.excelforum.com/showthread.php?threadid=40075