I recently upgraded from Excel 5 to 7 and now find that a macro I have that refers to more than one sheet in a particular workbook has somehow got its wires crossed. After operating the macro, whilst a particular sheet is protected, if I click anywhere on that sheet it tries without success to run another macro I have attached to the same workbook, which has no reference to this troubled sheet. If I unprotect the sheet, which I don't want to do, there is no problem.
I copied and pasted just the troubled sheet into a new workbook and the same problem has come along.
Also, can someone explain the filing 'structure' in the version 7 Visual Basic editor please? How do I find a particular macro within the trees offered in the two windows down the left margin?