Help with Hyperlinks
I am trying to do something new here, I haven't worked extensively with
hyperlinks before and I am not sure if what I am trying to do is even possible. So, here is a step by step description of my expectations: 1.) I have a ActiveX Label on my Worksheet 2.) I want to create an hyperlink in the "Click Event" of the Label that will: i.) go to another worksheet ii.) set the ScrollRow, and iii.) set the ScrollArea |
Help with Hyperlinks
something likePrivate Sub Label1_Click() With ThisWorkbook.Sheets("Sheet1") Application.Goto (.Range("D4")) ScrollArea = "C2:F7" End With ActiveWindow.ScrollRow = 3 End Sub ? -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=124509 |
All times are GMT +1. The time now is 08:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com