ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to simulate Control (button) and Mouse Selection of cell (https://www.excelbanter.com/excel-programming/403516-how-simulate-control-button-mouse-selection-cell.html)

Rick S.

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



All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com