Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command buttons disappear when I move worksheet 2007 | Excel Discussion (Misc queries) | |||
Move and reset valuse using a command Button | Excel Discussion (Misc queries) | |||
command button to move data | Excel Worksheet Functions | |||
VB command to move down one row | Excel Discussion (Misc queries) | |||
command button in excel will move when print. | Excel Discussion (Misc queries) |