Help with Macro to Globally Automate View/Zoom/Fit selection

[dcampbe1]

I am in need of a global macro that allows me to "view/zoom/select/ fit selection" selected columns. Ideally it would allow me to go to any sheet of any book, select the columns I want to autofit view, e.g., A:D, and click on a macro button to execute it.

I would be surprised if such a macro hasn't been written many times over but I am not able to find such a thing. Does anyone have an idea how I would find or write such a macro?

Thanks.

 

[Peter_SSs]

Welcome to the MrExcel board!

Not sure what Excel version you are using but it isn't many clicks anyway to do that manually.

However, if you want a macro, try

Sub Zooom()
    ActiveWindow.Zoom = True
End Sub