Application defined or object defined error - Not Caused by Code
One more piece of testing - I added a Command Button to one of the
sheets in the file and assigned the same "MyExit" macro to the new
button.
It works perfectly fine.
So - it is ONLY a problem when trying to run the code from a
commandbar button WITH other spreadsheets open.
I am sure I am not the only one to stumble accross this
BTW - I am running Excel 2003 if that makes a difference or helps at
all
Thanks.
Jeff
|