ExcelBanter - Assigning a macro to a button

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Assigning a macro to a button (https://www.excelbanter.com/excel-worksheet-functions/254610-assigning-macro-button.html)

hberg

Assigning a macro to a button

I would like to record a command to bring me to a different sheet on the same
workbook

Chip Pearson

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

All times are GMT +1. The time now is 02:08 AM.