Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks? | Excel Programming | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |