Application defined or object defined error - Not Caused by Code
On 4 dec, 18:41, JeffTO wrote:
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
Hi everyone,
I have exactly the same problem as Jeff described in detail.. I'm
activating the code via a added menubar. I'm also using 2003.
Just hoping there is a genius out there that can help us out.
Kind regards,
Il Poniente
|