Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Command Button to Hyperlink to a Different worksheet

I would like to use a command button to hyperlink to a particular page within
a workbook (and maybe a specific Cell)
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,092
Default Command Button to Hyperlink to a Different worksheet

It would be simpler to use a Forms Button, but for a CommandButton put this
in a general module:

Sub navsheet4()
Worksheets("Sheet4").Activate 'change to your sheet
Range("AA600").Select 'change to your cell
End Sub

With your CommandButton on sheet 1, put this in the Sheet1 code module

Private Sub CommandButton1_Click()
Call navsheet4
End Sub

Mike F
"Mikeyboy" wrote in message
...
I would like to use a command button to hyperlink to a particular page
within
a workbook (and maybe a specific Cell)



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
put a hyperlink on a command button Lloyd Excel Worksheet Functions 1 May 21st 07 01:27 PM
Command Button Hyperlink jgarner Excel Discussion (Misc queries) 2 April 27th 07 02:12 PM
How do I execute command from button or hyperlink? rerhart Excel Discussion (Misc queries) 1 February 18th 05 09:41 PM
setting a command button to be a hyperlink neowok[_70_] Excel Programming 0 July 15th 04 04:55 PM
login to worksheet from command button sil Excel Programming 1 February 19th 04 12:44 PM


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

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"