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:
Any help with this would be greatly appreciated!![]()
Please Login or Register to view this content.
Bookmarks