Active Sheet not automatically running macro

Hey,

I have a couple of macro's that run when I active specific sheets. On my main sheet there are hyperlinks to various other hidden sheets. I use the below code to allow them to activate when I click the hyperlink.

Please Login or Register  to view this content.

When Clicked it opens the sheet and then this Macro should run

Please Login or Register  to view this content.

But It doesn't. Which is my problem. It used to run the code before I decided it would be neater to hide all my sheets (there are lots of them, all based on a template that has this code embedded in it)
So it must be something about having them activated using the first macro. Is there anything I could add to the code that would ensure it runs?

Thanks in advance for any help.

R

You disable events before the target.follow command, which will disable the worksheet_activate module.

I would suggest:
putting the worksheet_activate code in a separate sub, perhaps "Sub MyActivate_Macro()" then in your worksheet_Activate sub and after the target.follow command you could put "call MyActivate_Macro"

Please Login or Register  to view this content.

Tried changing it to this, so it's actually activating the sheet. But to no avail

Enableevents = false !!!!!

Yudlugar, well spotted.

Getting rid of this line has solved my problem.

Please Login or Register  to view this content.

Thank you both for your help