command to move to different sheet

H

hberg

I would like to create a button to bring me to a different sheet within the
same work book
 
E

Eduardo

Hi,
create a button and apply the code as follow if the sheet is hidden

Sub Bring sheet()
'
' Bring sheet Macro
'

'
Sheets("your name").Visible = True
Sheets("your name").Select
End Sub

if sheet is not hidden use

Sub Bring sheet()
'
' Bring sheet Macro
'

Sheets("your name").Select
End Sub
 

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

Excell Otpions in office environment 0
Continues to move to the right 0
Section and Page numbering 0
How do you make a summary sheet? 0
Assigning a macro to a button 1
VBA Coding Help for Beginner 0
Combining two sheets of data into one and sorting by value - using macros 5
Images are pixelated when saving to PDF 0

Top