![]() ![]() ![]() What is quite misleading is the name of this event. We can now enter some code inside the Worksheet_FollowHyperlink sub provided. To access the Worksheet_FollowHyperlink event, select Worksheet from the Object list, and then FollowHyperlink from the Procedures list. The Title will display the currently active code window. We need to open the code window for the “Main” worksheet because that is where the event resides.ĭo this by double clicking on the sheet in the Project Explorer window. ![]() We need to use this code on the Worksheet_FollowHyperlink event so that it occurs when the link is clicked. Lets begin by opening the Visual Basic Editor by clicking Visual Basic on the Developer tab, or by pressing Alt + F11. Excel VBA to Follow Hyperlink to Hidden Worksheet ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |