| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 64 | 1998-09-08 15:59:00 | Excel macro disfunction after upgrading to V7 | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 311 | 1998-09-08 15:59:00 | 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? |
Guest (0) | ||
| 1 | |||||