View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Poniente[_2_] Poniente[_2_] is offline
external usenet poster
 
Posts: 6
Default 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