Hyperlink or Command Button

Dear forum members,

Mudraker helped me with a fully functional code to get the drive letter of CdRom.

From there I created hyperlinks to access the CdRom.

Now I need help with coding the following please.

On sheet1 I have a hyperlink in cell H21 to access 4 other applications on the CdRom for training purposes. The hyperlink can change from accessing Stock Counts.exe, or Random Stock Tracking System.exe, etc.

Is it possible to create a Command Button, which will "follow" the hyperlink to anyone of these applications on the CdRom?
Or can it be done with a Command Button alone, without following a hyperlink?

What do you recommend is the easiest, and what does the coding look like?


Thank you

Hello again,

I am sure there must be someone with an answer for me. Is it possible to access another application on the CdRom via a command button, and on closing that application to return to the active worksheet?

Thank you