VBA to put code programmatically in sheet-level macro

Question

I was trying to use Workbook_SheetFollowHyperlink() to trigger a macro if the user clicks the hyperlink.

However, this Workbook_SheetFollowHyperlink macro is to be inserted on a sheet-level, not on the module level.

Is there any way that I can programmatically add this Workbook_SheetFollowHyperlink macro to every sheet? The reason is, I create these sheets on the fly using VBA, and the number of sheets and their names are not known in advance beforehand.

chris neilsen · Accepted Answer · 2013-12-23 08:21:27Z

1

Workbook_SheetFollowHyperlink is defined in the ThisWorkbook class module. (At Worksheet level, it's Worksheet_FollowHyperlink)

So, you already have what you need: an Event that responds to following a Hyperlink on any sheet in the workbook.

answered Dec 23, 2013 at 8:21

chris neilsen

53.3k10 gold badges91 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Roy Over a year ago

Thanks. But is there a way that I could add codes programatically to the ThisWorkbook object?

chris neilsen Over a year ago

You can modify the VBA at run time (using Microsoft Visual Basic for Applications Extensibility 5.3 in Tools>References.)

Collectives™ on Stack Overflow

VBA to put code programmatically in sheet-level macro

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related