Assigning a macro to a button

  • Thread starter Thread starter hberg
  • Start date Start date
H

hberg

I would like to record a command to bring me to a different sheet on the same
workbook
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Resize image using macro 1
Macro code behind button 1
Collapsing all groups 0
command to move to different sheet 1
adding a control button with a filter 2
Create A Button and Assign A Macro To It 2
Assigning A Macro to A Button 1

Back
Top