ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trapping Double Click Short-Cuts? (https://www.excelbanter.com/excel-programming/276217-trapping-double-click-short-cuts.html)

Cordell[_2_]

Trapping Double Click Short-Cuts?
 
I have a drill-down type spreadsheet application where
the user can double-click a row on one sheet and is taken
to another sheet to see the detail for it (using
AutoFilter settings).

This works great except when the user accidentally double-
clicks on a cell border and is "helpfully" taken to last
row or column in the current sheet by Excel. I can't
seem to trap or detect that this is happening in my
BeforeDoubleClick event on the worksheet (nor in the
SheetBeforeDoubleClick event in the WorkBook object).

I would greatly appreciate any pointers on how to turn
this feature off or trap it in VBA code!


All times are GMT +1. The time now is 10:14 AM.

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