how to make macro open hyperlinks in excel 2011 for mac

Make Ro Open Hyperlinks In Excel 2011 Code Will Be

I am learning VBA and as a practice project am trying to make a nutritional tracker.

I am trying to make a hyperlink that, when clicked, runs a macro to add a new food entry row.

Obviously, running the macro via the hyperlink doesnt work either.

Here is a screenshot of my excel so you get an idea of what im trying to do.

After much frustration, I have found that the WorksheetFollowHyperlink does not work on Macs after Excel 2010.

I do not know why or if this is actually true, so if anyone has anymore insight into this, let me know.

Make Ro Open Hyperlinks In Excel 2011 Code Will Be

Still, any advice on cleaning up my macro code will be appreciated Thanks in advance.

Try putting Debug.Print Target.Range.Address outside of the If statement to make sure that A, the event handler is firing, and B, that the value of Target.Range.Address is what you expect.

I click the hyperlink and nothing happens.

Try dropping Application.EnableEvents True in a test sub and running it.

I also made a separate sub called TestSub() and tried it in there too.

Know someone who can answer Share a link to this question via email, Twitter, or Facebook.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Browse other questions tagged vba or ask your own question.

How To Make Macro Open Hyperlinks In Excel 2011 For Mac