Okay guys, so now we're going to speak about the workbook sheet follow hyperlink event, which actually gets triggered whenever you click on a hyperlink on any sheet in your workbook. Okay, so this is similar to the follow hyperlink event on the worksheets. Okay, so the worksheet follow hyperlink event, but it actually doesn't work on a particular worksheet, it actually can work in any worksheet. It's a global thing. It's, it works in on any sheet on your workbook, okay? And it's got two parameters.

This H, which is basically the sheet that ie the hyperlink exists in and the target which this The target is basically your hyperlink, the type of the object is a hyperlink. Okay, so I could create a hyperlink for example, I'm on sheet two right now it could create a hyperlink to sheet six. So I'm going to right click here, click on hyperlink, and we're going to click on Place in this document and I'm going to select sheet six So this is going to have a hyperlink, linking to sheet six. As you can see, when I click on it, I go to sheet six. So you could create a message box that says you are going to sheet six, and then from and then a space and then we close our double quotes and then an ampersand sh dot name. So this should be triggered when we click on the hyperlink and it's going to say you're going to sheet six from sheet two, because the hyperlink is in sheet two, and we refer to it using the S h parameter.

So when you click on the link here, says you're going to sheet six from sheet two. Okay? So that's simply the follow hyperlink event A works the same way as in the sheet events. So that's it. Thank you very much, guys for watching. watching this video, I'll see you on the next one.