Excel & Skype | assigning "tel:" to a button

[manc]

Good morning,

I have the following formula in A1:
=IF(D22="","",HYPERLINK("tel:"&VLOOKUP(D22,TR_Contacts_Data,4,FALSE)))

It looks up the phone number against the chosen contact name from a drop-down list in D22.

Works great - I can click on A1 and it links with Skype and dials the number.

What i want, is instead of me having to click on cell A1, i want a nice "phone" button, so you click on the button and it dials the number in A1 for you.

Any ideas? I've looked on the web and there used to be a Skype for office toolbar but it isn't compatible with our version of office, and, is no longer available for download from official channels anyway.

It sounds pretty easy to do - assign a macro to the button whereby the macro runs the hyperlink.
Just need to know the code to put.

Any help or pointers, greatly appreciated as always.

 

[manc]

Re: [SOLVED] Re: Excel & Skype | assigning "tel:" to a button

cooper645 - it's a good idea not thought of yet! However, WBD has solved it with a one-liner!

Thanks for your suggestion WBD - works perfect - thank-you.

Best regards
manc