You can do this by enabling the Developer tab in Excel Options, selecting Design Mode, and inserting a Button form control.
When you insert the button control, Excel should open the macro dialog with a macro name like Button1_Click. When you see that, click New on the macro dialog. This will open the event handler for the Button#_Click event in the Visual Basic editor. You'll need to add a line of code to the event handler, so that it looks like this...
' this is a comment...
Replace CustomViewName with the actual name of the view you want to show. When you leave design mode and click the button, it should show your custom view. Just add a button and repeat for each view.