View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Moses[_2_] Moses[_2_] is offline
external usenet poster
 
Posts: 2
Default Excel 2003 won't run simple code that Excel XP and Excel 2000 will run

Hi All,

I was wondering if anyone had come across this problem. I have two
separate applications in which Excel 2003 will not run my code.

On one application, it won't recognize a userform when I am in a sub,
but if I call the userform in the parent sub that calls the problem
sub, it will recognize it. Strange!

In the other one, the code is simple:
thisworkbook.activate
sheets("data entry").activate

It chokes on the 2nd line.

I even tried:
thisworkbook.activate
x = activesheet.name

and it choked on that too.

The error is: Run-time error '32809'
Application-defined or object-defined error.

Any ideas?