creating a button to activate another worksheet within a workbook

[Guest]

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?

 

[Guest]

It would be easier to respond if you could explain the conditions that would
prompt the user to change worksheets.

 

[Guest]

The workbook contains in excess of 50 worksheets.

I want to put a series of buttons on the master sheet that will each
activate a unique worksheet. It is motivated by convenienve to ensure that
the user doesn't have to scroll through across the worksheet tabs in an
attempt to locate the desired worksheet to edit/review/print.

 

[Tom Ogilvy]

You can right click on the "VCR" controls on the lower right corner of the
window and get a list of sheets, then select one to go to it.

otherwise, it might be better to use hyperlinks using the hyperlink
worksheet function to do what you want.

You might look here: http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[Guest]

Thankyou for your assistance Tom. Most helpful.

You can right click on the "VCR" controls on the lower right corner of the
window and get a list of sheets, then select one to go to it.

otherwise, it might be better to use hyperlinks using the hyperlink
worksheet function to do what you want.

You might look here: http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[NickHK]

Tom,
You mean "lower-left" not 'lower-right" ?

NickHK

 

[Tom Ogilvy]

True, but do you see any VCR controls in the Lower-right?
Mickey seems like a bright boy. <g>

Thanks for weighing in.

 

[Guest]

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