View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default creating a button to activate another worksheet within a workb

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

NickHK

"Tom Ogilvy" wrote in message
...
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 he http://www.mvps.org/dmcritchie/excel/buildtoc.htm

--
Regards,
Tom Ogilvy


"Mickeyjay71" wrote in message
...
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?