Hi Mickeyjay71

you could create a command button using the control box menu bar onto your
sheet. then in design mode, double click on the button and type this in:

Worksheets("sheet2").Select

Thats all you need to do. Change whats in the prentices to the correct name
of your work sheet.

Hope this helps

Dave

"Mickeyjay71" wrote:

I have a large workbook and would like to create a button on a worksheet that
will switch the user to an existing worksheet within a workbook.

What are my options?