Hi Mr. Excel Forum,
I am designing a custom ribbon that will be distributed across different people's computers. One of the functions I have included in this ribbon is the ability to download a table of sorts where it lists the total issues outstanding. While this table only lists out the total issues outstanding, my manager would like to be able to click that total and have it display the details that lead to that total (similar to pivot table functionality). I have been trying to find a way to add a hyperlink via VBA to then call a module that will display the details but I can't seem to find a similar solution.
Has anyone else had any experience with this type of issue?
Thank you in advance,
silver9
I am designing a custom ribbon that will be distributed across different people's computers. One of the functions I have included in this ribbon is the ability to download a table of sorts where it lists the total issues outstanding. While this table only lists out the total issues outstanding, my manager would like to be able to click that total and have it display the details that lead to that total (similar to pivot table functionality). I have been trying to find a way to add a hyperlink via VBA to then call a module that will display the details but I can't seem to find a similar solution.
Has anyone else had any experience with this type of issue?
Thank you in advance,
silver9