VBA Code to go to Custom View

Hi Experts!

I'm looking for a VBA code to go or to open Custom View on the toolbar. I tried to record the macro, but unfortunately, it couldn't. I hope anyone can help me, and I appreciate any help you can provide.

Originally Posted by Andy Pope

Macro recorder spat this out in my simple test.

Please Login or Register  to view this content.

Thank you for your reply; I appreciate it. Yes, it will go to the target we set using this code. But I'm looking for a VBA code in which I can open the "Custom View" with one click button, not click the button to run the command from the Custom View.

For example, I want to go to the Custom View, so I need to go to View on the toolbar and then click Custom View. That's it.

Thank you again, Sir, for your feedback.

Originally Posted by Andy Pope

To show the actual dialog

Please Login or Register  to view this content.

YES, that it is! Many thanks, Sir Andy Pope. You are my hero!