Opening MP3 files without security warning

[abtabt]

I need some help with opening mp3 files. I have along list of mp3 files, each has a different file path. I have a cell in each row that has a hyperlink to launch the mp3. This works, but every time I open an mp3 file I get a security warning. I’ve exhausted every option I can think of to turn off this error, nothing seems to work.

My next approach is a macro to launch the mp3. This works and doesn’t have any security warning, the issue here is it is not very intuitive having a single button not near the row. I tried the same approach with an activex button aligned to a cell in the active row. This worked great until I discovered that the code that moves the button to the current row also kills undo so that’s out.

The third option was a hyperlink referencing its own cell and running a macro that opens the mp3. This also works without the security warning, but this means I’d have to create a hyperlink in every row, fill down doesn’t dynamically change the reference.

So that’s where I’m at. Each approach is close but has a deal breaker problem.

 

[Marc L]

​

You may use a worksheet event like double click and launch the file via the Workbook.FollowHyperlink method​

with its Address parameter allocated by the content of the cell, to see in VBA help …​

 

[abtabt]

​

You may use a worksheet event like double click and launch the file via the Workbook.FollowHyperlink method​

with its Address parameter allocated by the content of the cell, to see in VBA help …​

Thanks. I've tried this and it works, but I need a hyperlink for every row, how can I fill down the cell and have the link dynamically update?

 

[Marc L]

​

No need to create any hyperlink if you double click on a cell containing the mp3 full path​

so just requiring some codeline like ThisWorkbook.FollowHyperlink Target.Text as explained in VBA help …​

 

[abtabt]

​

No need to create any hyperlink if you double click on a cell containing the mp3 full path​

so just requiring some codeline like ThisWorkbook.FollowHyperlink Target.Text as explained in VBA help …​

Sorry, I misunderstood. That's double click is probably not going to work, I need something more obvious like a link or a button.

 

[abtabt]

I found a solution using Workbook.FollowHyperlink, if you create a hyperlink object that links to a file with the address of a ? question marks it works without an absolute reference. This can then be copied to whatever cells you like.