Dear Forum
Please find attached my spreadsheet with two modules. The first module is called “Tree” and does a lovely expanding and contracting tree when you click on “+” or “-“. The second module is called “TextSearch”. When you click on the button on the first worksheet it allows you to do a text search across the entire workbook, creates a sheet called “FindWord” and populates this sheet with hyperlinks to where the text is to be found.(try searching for “bread”) It replicates the “find all” functionality built into Excel. The problem is that when you click on the button and conduct a text search, it prevents the expanding and contracting procedure from working properly.
Can anyone identify what code needs to be inserted to allow these two procedures to run happily alongside each other?
As always any help is greatly appreciated.
Regards
Scott N
Bookmarks