Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel with Visually Impaired and ZoomText | Setting up and Configuration of Excel | |||
Visually Impaired Using Excel with ZoomText | Excel Discussion (Misc queries) | |||
Visually add (graph) vectors | Charts and Charting in Excel | |||
How can I visually display slope in an excel chart? | New Users to Excel | |||
Can not visually see the shading on the EXCEL file? | Excel Discussion (Misc queries) |