View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default command to move to different sheet

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