URGENT - make drop down box select open file automatically

need this a.s.a.p.

I have attached an example sheet with something that should be easy for you ...

to sum up - need a drop down box - that when "flange" is selected - It opens a file automatically - no clicking etc. just when that option in the drop down box is chosen.

thanks


ps. what I tried initially was something like this..

Please Login or Register  to view this content.

but doesn't work, plus means I have to click on something.. etc

You need something like:

Please Login or Register  to view this content.

It needs to be put in the worksheet object module, not a standard module.

thanks ill try that.

also - the problem I have is.. I want the heading and the drop down box to be on the same cell... but when I select something from the drop down box I don't want the orginal heading to change to what I chose.

e.g. like a website would have a drop down box

i.e. drawings not drawings - which changes to flange in the cell
flange

unfortunately the code in the module doenst work

the heading of the cell just gets changed to "flange" when I select it but nothing opens and the file is the correct name and stored in same folder as the sheet

check your file name "\file.pdf"

file name is fine.

Code is working pdf cannot be open in excel, change it e.g file.txt it will work

Sorry, I didn't notice it was a .pdf not a workbook. Change:

Please Login or Register  to view this content.

to the below, changing path names as appropriate.

Please Login or Register  to view this content.

(you can also use activeworkbook.followhyperlink but it is slower I think.)