Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
2-part question:
#1) How do I fire event code by clicking a hyperlink? I dont want to go to a web site; just want to run a macro. Im just looking for a way to click a hyperlink and fire some code. Spent a bit of time searching online for a solution but didnt see anything. #2) How do I copy/paste objects, such as radio buttons and some check boxes, from a row above my active row, insert a row, and paste the objects there? Heres the code that Im fiddling with now: Private Sub worksheet_selectionChange(ByVal Target As Range) If Target.Address = "$A$15" Then ActiveCell.Offset(1, 0).EntireRow.Insert ActiveCell.Offset(-1, 0).EntireRow.Copy Rows(ActiveCell.Row).PasteSpecial End If End Sub The Hyperlink part isnt working and the copy/paste objects part isnt working. Appreciate any help with this! Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use Scheuled Tasks to fire Event Code | Excel Programming | |||
Event drivin copy and paste code | Excel Programming | |||
Copy Sheet causes Combo Box change event to fire on original sheet | Excel Programming | |||
event fire | Excel Programming | |||
Event doesn't fire | Excel Discussion (Misc queries) |