zoom macro

[kalpeshpatel]

ANY Macro for zoom for worksheet1 is 150% zoom

 

[SirJB7]

Hi, kalpeshpatel!


The code is:

-----

[pre]

Option Explicit

Sub Macro1()
ActiveWindow.Zoom = 150
End Sub

[/pre]
-----


Or use the slider at bottom right of the page.


Regards!

 

[kalpeshpatel]

nice answer

thanks for help

 

[SirJB7]

Hi, kalpeshpatel!

You're welcome. And let me give you this little advise.

I didn't know how to zoom a window using VBA code, but I knew it was possible. So what did I? I started recording a macro (bottom left button), performed the actions needed in the menu (View, Zoom, Custom), entered the 150 value, pressed enter, and stopped recording the macro. What were the results? Alt-F11 to go to VBA editor, check for new modules, open the last one... and the code was there.

For simple (or complex too) actions you can try to record or create your own macros. It's simple and one of the better ways to learn how VBA works.

Hope it'll be useful for you.

Regards!

 

[Istiyak]

Heeyyyy SirJB7,,


I m also using the same method to learn and impliment the VBA...


Kalpesh,,, good hint for you from SirJB7


Cheerrrrsssss !@@@#


Regards

Istiyak

 

[SirJB7]

Hi, Istiyak!

Glad to read you're improving like that in Excel.

Welcome anytime you need.

Regards!