Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
command buttons disappear when I move worksheet 2007 moulage Excel Discussion (Misc queries) 1 January 25th 10 08:56 PM
Move and reset valuse using a command Button Chris Excel Discussion (Misc queries) 0 December 29th 09 11:54 PM
command button to move data dummy Excel Worksheet Functions 3 December 5th 09 06:44 PM
VB command to move down one row merry_fay Excel Discussion (Misc queries) 1 December 13th 07 01:14 PM
command button in excel will move when print. [email protected] Excel Discussion (Misc queries) 1 December 29th 04 03:53 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"