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
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
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.
Google is your best friend!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks