![]() |
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