M
Moses
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?
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?