running a macro from hyperlink

[dschmitt]

I found on the internet a script to run a macro from a hyperlink. See script below.
I created a hyperlink in A1 to A1 (see picture below), but the MsgBox does"t appear if I click the hyperlink.
I have no idea why. Does anybody know what I might be doing wrong?

Please Login or Register  to view this content.

example.jpg

[dschmitt]

I found the problem.
I put the script into a module. That doesn't work.
The script needs to go into the scripting box of the Sheet (in Microsoft Excel Objects) that contains the hyperlink.

[Keebellah]

I've never done it but as what's in cell A1?

Wait.

You can refer to a macro but the macro MUST be in the VBAProject of the workbook NOT the VBAProject of the skeet.

And you will have to write the macro sometjhing like

Please Login or Register  to view this content.

This was done out of hand so you'll have to check for syntax errors, but this is main idea

[Keebellah]

I just wrote and tested something:

Place the code below in a (new) module and run 'runAmacro'

Please Login or Register  to view this content.

A hyperlink won't work for this in any way.

You can create an event like right click on Cell A1 to run the macro or place a button on the sheet or attache the macro to the QAT ribbon

[dschmitt]

Keebellah, try my macro. It is working perfect as long as the macro is in the VBAproject of the sheet.
The hyperlink in the cell doesn't need to point to anywhere. But since you have to give it a destination you just point it to itself.
The hyperlink is then used to execute the macro.

One can use the cell address like in my example above or by using cell content of the hyperlinked cell as in the example below.
These are just two examples. Once you have this basic framework working many things can be implemented.

Please Login or Register  to view this content.

[Keebellah]

True, mine was just a quick-and dirty.
I have some variations and extra functionality in some code I wrote earlier but I guess the OP is not waiting for that