Radio Buttons Macros Hyperlinks and Moving Back

tmort

New Member
Joined
Aug 18, 2002
Messages
13
I'd like to insert some radio buttons in a worksheet that activate a hyperlink to a web page and then be able to go back to where I started (ie the radio button)

I can link the button to a macro which was a recording of clicking on a hyperlink. The trouble is when I hit the return arrow to return to the sheet from the web page I go back to the location of the hyperlink not where I started from.

Is there a way to do this with the buttons.

If I can rearrange the sheet to allow for more narrow columns I may be able to just use the hyperlink friendly name argument and do it that way but I'm not so sure I can insert more narrow columns without messing up the layout of the whole sheet. With a button I can float several of them over an area regardless of the width of the columns.

Thanks for any help
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

sandeepafpl

Board Regular
Joined
Aug 11, 2012
Messages
120
Hi all,
My problem is slightly different from previous one. I have prepared CMA data for 3 banks. I want 3 radio buttons with hyperlink on my first sheet i.e. summary sheet which be linked to 3 bank's data and except summary sheet all worksheet will be hidden or locked. How is it possible?

Sandeep Giri
 

Watch MrExcel Video

Forum statistics

Threads
1,130,336
Messages
5,641,565
Members
417,222
Latest member
Broflovski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top