Infraction: 6. Do not post unless you have something new and worthwhile to say.
Message to User:
This is the wrong thread for this post and you already posted the exact same thing in the correct thread. It's unnecessary, please don't do that.
I posted this in the other spreadsheet thread also, as both spreadsheets produce the same error:
I am using Excel 2003. If this is the root of the issue, please let me know. As far as I know, spreadsheets are relatively backwards compatible.
The error occurs when I try to mouse over the "Load Gear from Armory" button on the "Gear" tab. The MS Visual Basic debugger comes up and two error messages are displayed. They are the same and say: "Compile Error: Automation Error".
The debugger highlights the Private Sub Worksheet_Change(ByVal Target As Excel.Range) function when this occurs.
Is anyone else having this issue? (macros are enabled btw)