hyperlinking custom views

  • Is it possible to hyperlink to a custom view? If not, does anyone have suggestions as to how i could create a list of tables that connect to custom views (other than using the custom views drop-down menu)? thanks.

  • One way is to put buttons from the Forms toolbar for each custom view, then use the macro recorder to generate code like this:


    Sub MyView1()


    ActiveWorkbook.CustomViews("MyView1").Show
    End Sub


    and then right-mouse click on the button and assign the macro to the button

  • That should be asign with 2 s's. It appears that this board automatically replaces an a followed by 2 s's with the word bottom. What's up with that?