Linking

rajatsingh78

New Member
Joined
May 17, 2005
Messages
27
Hi Guys,

I am creating a workbook with multiple sheets, on the main sheet I have inserted a drop down menu using "Data Validation"-->List. Right now I select an item from the list and then a hyperlink comes up below the drop down box, I want to change this.

I want that as soon as I select an item from the drop down (by using data validation or any other method) the related sheet open up automatically.

Please help me in this.

Thanks in advance,

Cheers!!
Lucky
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
suppose the hyperlink is placed in cell A3:

edit the worksheet_change function and place code like this in it:

if Target.Address = "A3" then
application.workbooks.open (Target.value)
end if

this will open the target from the hyperlink I think (maybe need some adjustment, I don't have Excel here to test it)
 
Upvote 0
what part of it is not working? are you familiar to vba?
if the hyperlink is generated using a formula you should use the
worksheet_calculate function instead.
 
Upvote 0

Forum statistics

Threads
1,219,027
Messages
6,145,854
Members
450,652
Latest member
JR1

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
Back
Top