Catalin.B - I'm so grateful for your help.

I followed your comprehensive instructions to the letter (of course - lol)
Activated the macros in Exel 2007 - however what I found in Trust Centre/Trust Centre Settings/Macro Settings/ there was no "medium level" to be found.

So I chose and clicked the radio button; "enable" and the check box; "trust access to the VBA Project Object Model.

I saved the file as a .xlsm and re-opened the work book. Attempted to get the benefit of your macro and created a hyperlink to one of the listed videos, but it behaved the same as before and didn't open as I expected in the desired directed.

In the macro I replaced the appropriate text with 'N:\video\movies\

More help would be appreciated if you have the time - I understand it's the Holiday Season.

Cheers, Mal