creating a button to activate another worksheet within a workbook
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?
|