command to move to different sheet

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

hberg

I would like to create a button to bring me to a different sheet within the
same work book
 
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
 
Back
Top