command to move to different sheet

  • Follow


I would like to create a button to bring me to a different sheet within the 
same work book
0
Reply Utf 1/27/2010 4:46:07 PM

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


"hberg" wrote:

> I would like to create a button to bring me to a different sheet within the 
> same work book
0
Reply Utf 1/27/2010 5:13:01 PM


1 Replies
2575 Views

(page loaded in 0.055 seconds)


Reply: