View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick S. Rick S. is offline
external usenet poster
 
Posts: 213
Default How to simulate Control (button) and Mouse Selection of cell

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