How to create a button to switch to a custom view

T

Turquoise_dax

Once you add add a custom view, I would like to know how to create a
button to allow the user to switch views without having to scroll in
the menus.

Thanx
 
B

Bearacade

create a button, double click on the button while you are still in
design mode and enter this in the sub:

ActiveWorkbook.CustomViews("???").Show

put in the name of your Custom View in ???

I would save a version as "normal" and make a button for that too.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top