Use the macro recorder and copy and paste the code from the macro you
recorded into the CommandButton1_Click() event of the button.

"Hugnuffer" wrote:

I am setting up an index worksheet with a list of different areas on the main
worksheet. I have inserted buttons on the list, but don't know the visual
basic to get them to send the user to the specific custom views for each area
of the other worksheet.