How to use command buttons to link to worksheet?

  • Thread starter Thread starter jembry
  • Start date Start date
J

jembry

I have a problem.

I am trying to figure out how to use a the command button to link th
worksheet with the command botton to another worksheet within the sam
file.

Much like using a hyperlink to pull an external file but in this cas
simply going to another worksheet in the same file
 
Just put

Worksheets("Sheet2").ACtivate

in the button macro, or click event code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

How to use multiple command button to copy user form data to multiple worksheet 0
command button to move data 3
Assign a function to a Command Button 3
How to link different worksheets into the 1 menu on a septerate sh 1
Command Button 11
Linking item between two worksheets 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Button to open JPG (Hyperlink) 1

Back
Top