On Sep 23, 1:13*pm, Winnipeg Michael
wrote:
I have a custom view, that I would like to turn into a macro, so I can click
a button, instead of having to click the Custom View button and subsequent
clicks.

Does anyone have one already made, or can share what I need to do to write
the macro?

Thank you

Winnipeg Michael:
Attached is the code you can use. Replace the "MyView" with the name
of your custom view.

ActiveWorkbook.CustomViews("MyView").Show

Best of luck.

Excel.Instructor (Ed2go.com/Advanced Excel)