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.
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.