Hyperlink & filtering combined

[jbondot]

Hi guys

I'm currently trying to get a hyperlink and filtering process to work together.

In "Sheet 1" I've place 2 hyperlinks that will refers to "Sheet 2". I would like to have it so that if the user is clicking on the hyperlink, the associated text will be filtered within "Sheet 2" automatically.

I can get this to work while stepping through the code but it doesn't want to work properly without it being stepped through.

Comments are appriecated.

[jbondot]

The hyperlink function can be replaced with another one instead.