aommunoz
10-05-2007, 06:36 AM
Hi,
I have an Excel2003 application with two spreadsheets.
Sheet1 contains visualization of data seleted with a drop drown menu associated with a VBA Macro.
I want to add hyperlinks to the sheet2 that
1-show sheet1
2-trigger a macro to update the values in sheet1.
I do not manage to trigger a macro by just clicking on a hyperlink.
I have seen related posts that did not help me up to now but never a generic way as to how to trigger a macro by a hyperlink.
Thanks for your help.
I have an Excel2003 application with two spreadsheets.
Sheet1 contains visualization of data seleted with a drop drown menu associated with a VBA Macro.
I want to add hyperlinks to the sheet2 that
1-show sheet1
2-trigger a macro to update the values in sheet1.
I do not manage to trigger a macro by just clicking on a hyperlink.
I have seen related posts that did not help me up to now but never a generic way as to how to trigger a macro by a hyperlink.
Thanks for your help.