I currently have various custom ribbon buttons in a custom tab that launch macros which are all hyperlinks to; other worksheets, work docs, mailto and webpages. Is there any way to have native ribbon only code as users keep saving the files as xlsx files which dumps the macros? I am currently building the custom tab and buttons in unofficial customUI tool. I was hoping to be able to use the xml in this to somehow trigger the hyperlinks. Or will I have to use visual studios?
Excel 2010 & 2013
Any info gratefully received thanks