Double click navigating to referenced cells

[mikeymay]

I have a double click event set on a range that contains lots of formulas.

The event selects and scrolls to column and the row that was double clicked so that row is at the top of the screen.

However, as the cells in the range contain formulas referencing some hidden cells, after the event scrolls to B27 (for example if a cell in row 27 was clicked), it then selects the cells in the hidden columns that are to the right of the range.

Is there a way of turning off the built in double click event where it will select the referenced cells?


Thanks

 

[6StringJazzer]

It should be possible for the code to check each cell before selecting it to determine if it's visible. How are the cells hidden--hidden row? hidden column?

However, it is not possible to give you any real help without having your code. Please paste the code for the entire Sub Worksheet_BeforeDoubleClick here, and mark it as code with the VBA button on the edit controls.