I have a sheet that has hyperlinks to many other workbooks. Is there any way that when the hyperlink is clicked that a macro runs in the workbook that is opened by the hyperlink?

I only want this macro to run when this hyperlink is clicked and not when the hyperlinked workbook is opened in another fashion.

I have the macro imbedded in the hyperlinked workbooks.

Is this possible, thanks in advance

Mike