View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JeffTO JeffTO is offline
external usenet poster
 
Posts: 14
Default 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