| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a button to activate another worksheet within a workbook
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a button to activate another worksheet within a workbook
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a button to activate another worksheet within a workb
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a button to activate another worksheet within a workb
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a button to activate another worksheet within a workb
Thankyou for your assistance Tom. Most helpful.
"Tom Ogilvy" wrote: 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a button to activate another worksheet within a workb
True, but do you see any VCR controls in the Lower-right?
Mickey seems like a bright boy. <g Thanks for weighing in. -- Regards, Tom Ogilvy "NickHK" wrote in message ... 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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Command Button on a worksheet | Excel Discussion (Misc queries) | |||
| Creating some sort of button that will take you to a new worksheet | New Users to Excel | |||
| activate last worksheet in a different workbook | Excel Programming | |||
| Workbook.Activate / Window.Activate problem | Excel Programming | |||
| activate a worksheet formula through a button | Excel Discussion (Misc queries) | |||
Linear Mode
