Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using builtin sheet activator
When you right click the arrow keys in the bottom left hand corner you
get a menu that has 9 or 10 sheets that you can go to. It also has a menu item "More Sheets" from which you can activate any worksheet in the workbook. I would like to bring up that More Sheets form to allow the user to select a worksheet in one of my macros. Also, it might be convenient if i could add it below Edit | Go to as a sheet activator, so that I no longer have to use the mouse. Is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using builtin sheet activator
Per Chip Pearson (29 Oct 2002)
On Error Resume Next Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute -- Hope this helps, James dot Becker at NCR dot com ~ ~ ~ :wq! "R Avery" wrote in message ... When you right click the arrow keys in the bottom left hand corner you get a menu that has 9 or 10 sheets that you can go to. It also has a menu item "More Sheets" from which you can activate any worksheet in the workbook. I would like to bring up that More Sheets form to allow the user to select a worksheet in one of my macros. Also, it might be convenient if i could add it below Edit | Go to as a sheet activator, so that I no longer have to use the mouse. Is this possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using builtin sheet activator
Fantastic. =)
Jim Becker wrote: Per Chip Pearson (29 Oct 2002) On Error Resume Next Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no builtin chart options for me..(Excel 2000)!! | Charts and Charting in Excel | |||
VB .NET Excel Builtin Property Access fails | Excel Programming | |||
Workbook Builtin Property - display in Windows Explorer? | Excel Programming | |||
Setting Excel toolbar or menu icon in C# WITHOUT using builtin icons | Excel Programming | |||
Builtin Properties | Excel Programming |