Excel view code - BeforeDoubleClick function

[Saarek]

Hello everyone, thank you for taking a look.

I have an excel sheet that has a list of companies, each company has a number of branches underneath. These branches are hidden from view, using the BeforeDoubleClick function I want excel to run a macro and then un-hide the specified rows if a company name cell is double clicked on.

My VBA code under the spreadsheet works, but for some reason it will only work once and then default behaviour of double clicking on a cell to edit resumes.

I have to close excel completely for the code to function again. Very confused.

Here is an example of my code:

Please Login or Register  to view this content.

Any help with this would be greatly appreciated!

[JosephP]

where's the code for Hide_All? does it disable events?

[Saarek]

Hello everyone, thank you for taking a look.

I have an excel sheet that has a list of companies, each company has a number of branches underneath. These branches are hidden from view, using the BeforeDoubleClick function I want excel to run a macro and then un-hide the specified rows if a company name cell is double clicked on.

My VBA code under the spreadsheet works, but for some reason it will only work once and then default behaviour of double clicking on a cell to edit resumes.

I have to close excel completely for the code to function again. Very confused.

Here is an example of my code:

Please Login or Register  to view this content.

Any help with this would be greatly appreciated!

Sir, I could kiss you! I spent hours playing around with the code when it was the Macro at fault the whole darn time.

1000 times thank you!

[JosephP]

it's ma'am actually but you're welcome ;-)

[Saarek]

Whoops, my fault for looking at the picture and making assumptions. Thanks once again

[JosephP]

it's ok I've gotten used to it :-)