| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning a macro to a button
I would like to record a command to bring me to a different sheet on the same
workbook |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assigning a macro to a button
Use Application.Goto. For example, Application.Goto ThisWorkbook.Worksheets("Sheet3").Range("A1"), True If you don't need to go to a specific cell, you can Activate the desired sheet: Worksheets("Sheet4").Activate Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Wed, 27 Jan 2010 11:41:03 -0800, hberg wrote: I would like to record a command to bring me to a different sheet on the same workbook |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning A Macro to A Button | Excel Worksheet Functions | |||
| assigning a macro to a button | Excel Discussion (Misc queries) | |||
| assigning macro to button | Excel Discussion (Misc queries) | |||
| Assigning macro to button | Excel Discussion (Misc queries) | |||
| Assigning a macro to a "button" | Excel Discussion (Misc queries) | |||
Linear Mode
