R
Rick S.
I have tried using macro recorder to see the difference of selecting a cell
with a mouse and selecting a cell with the Control button pressed and the
mouse. The only thing I see in VBA text is ".Select" or ".Activate". Yet
when used in VBA both work the same?
Scenerio:
I have named cells with hyperlinks to other named cells, I have created a
Map (worksheet) of hyperlinks to all hyperlinks in the workbook. When I
click on a named cell hyperlink, "SS_1", I would like to only go to the cell
and not continue thru hyperlinks from the cell (SS_1).
Each hyperlink may have one or more associated hyperlinks, makes for quick
sheet and cell changes.
Is there a simpler method?
Can hyperlinks be "Double Clicks"?
Can I program the use of the "Control" button when selecting cells?
--
Regards
VBA.Noob.Confused
XP Pro
Office 2007
with a mouse and selecting a cell with the Control button pressed and the
mouse. The only thing I see in VBA text is ".Select" or ".Activate". Yet
when used in VBA both work the same?
Scenerio:
I have named cells with hyperlinks to other named cells, I have created a
Map (worksheet) of hyperlinks to all hyperlinks in the workbook. When I
click on a named cell hyperlink, "SS_1", I would like to only go to the cell
and not continue thru hyperlinks from the cell (SS_1).
Each hyperlink may have one or more associated hyperlinks, makes for quick
sheet and cell changes.
Is there a simpler method?
Can hyperlinks be "Double Clicks"?
Can I program the use of the "Control" button when selecting cells?
--
Regards
VBA.Noob.Confused
XP Pro
Office 2007