ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   command to move to different sheet (https://www.excelbanter.com/excel-worksheet-functions/254599-command-move-different-sheet.html)

hberg

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

Eduardo

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



All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com