Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Sheet Display Zoom Magnification in VBA
Greetings! I am working in Excel 2000 and am looking for the VBA command to
allow me to set the Worksheet Zoom Magnification programmatically. The toolbar has the handy little dropdown list box, but I haven't been able to figure out how to do this in code. I found the Zoom command, but that seems to refer only to page setup for printing. Thanks in advance! -- Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Sheet Display Zoom Magnification in VBA
Hi, ActiveWindow.Zoom = 85 would set the zoom to 85%.
In the VBA editor if you press F2 it will bring up a search window to search the VBA libraries for built in functions, properties, and methods. This is very helpful to find things like this. HTH--Lonnie M. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Sheet Display Zoom Magnification in VBA
Thanks, Lonnie!
That seemed the logical choice, but when I checked the Excel help files it kept referring to changing the zoom for printing. VBA's help file leave a lot to be desired. Thanks again for your help! "Lonnie M." wrote: Hi, ActiveWindow.Zoom = 85 would set the zoom to 85%. In the VBA editor if you press F2 it will bring up a search window to search the VBA libraries for built in functions, properties, and methods. This is very helpful to find things like this. HTH--Lonnie M. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Sheet Display Zoom Magnification in VBA
Kevin,
Another easy way to find this kind of information out is to record a simple macro. I just did a "Tools, Macro, Record new macro", typed in Zoom for the name, then zoomed to a couple of different settings and stopped recording. Then I went to the VBA editor and there was the code. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Sheet Display Zoom Magnification in VBA
Dave:
You're absolutely right. I have used that method of recording a macro then looking at the code in the past and I'm not sure why I didn't think of it this time. Is it Friday, yet? :-) Thanks! "davegb" wrote: Kevin, Another easy way to find this kind of information out is to record a simple macro. I just did a "Tools, Macro, Record new macro", typed in Zoom for the name, then zoomed to a couple of different settings and stopped recording. Then I went to the VBA editor and there was the code. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Sheet Display Zoom Magnification in VBA
Seems slow getting here this week....
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I limit Zoom feature magnification to just one column? | Excel Discussion (Misc queries) | |||
Change Magnification default global setting | Setting up and Configuration of Excel | |||
Setting Default Zoom | Excel Discussion (Misc queries) | |||
Setting the magnification to a range of cell's | Excel Discussion (Misc queries) | |||
Value of Zoom print setting | Excel Programming |