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.

"JLGWhiz" wrote:

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

"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?