View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh Sale Josh Sale is offline
external usenet poster
 
Posts: 177
Default Can't set Application.Interactive

I have an XL2003 add-in that includes a line like:

Application.Interactive = False

Normally the statement executes just fine. However under some weird (I
can't characterize it yet) but repeatable circumstance, this statement will
throw the following 1004 run-time error:

Method 'Interactive' of object '_Application' failed

Has anybody seen this kind of thing before? If I look at the Application
object in the Watch window, all of its public properties look OK.

TIA,

josh