Command Button Hyperlink

G

Guest

I have a command button (CommandButton1) on 'Sheet1' of an Excel spreadsheet.
I would like to be able to click on the command button and have it take me to
'Sheet2!A1'. What is the code that is entered into the module?
 
G

Guest

hi,
Sub macGoTo()
Sheets("sheet2").Activate
Range("A1").Select
End Sub

But why not just click the tab?????

Regards
FSt1
 
G

Guest

Thanks for your help. And yes, I could just click on the sheet tab, and I
could also use text in a cell as the hyperlink (which makes it very easy),
but it is an Excel feature that I wanted to learn how to do, and I also have
to create a spreadsheet for users that has hidden sheet tabs and is a
protected document to prevent users from changing the layout.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

activating a command button 1
Access Automatically Send a notification email once a record is added 0
Command Buttons 3
Command Button Help 2
Control Access 3
Problem with command button name 10
Command Button and macro 4
Command Button Blink Color 0

Top