runtime error 32809

Suddenly I started getting runtime error 32809 when running a certain macro. It only does it when trying to select or activate a certain sheet. I verified the sheet name was correct. I also tried renaming the sheet and the corresponding code. When that failed, I made a copy of the sheet, deleted the old one, and tried again with a new sheet and a new sheet name. Excel still spit out the runtime error.
Here's the kicker - this runtime error only comes in on a certain machine. I tried the macro from 2 other computers and the macro functioned properly. I am just confused why it will only do this particular worksheet and on a particular computer.

The runtime error occurs from: Sheets("Data Entry").Select or Sheets("Data Entry").Activate

I have not installed any kind of updates recently. Any ideas on what could be causing this?

Thanks!!

Hi jonrack.

It sounds like an 'Active X' corruption.

If what you say is true, the following sometimes fixes the error:
a. Make a copy of the offending sheet
b. Delete the original offending Sheet
c. Rename the copy back to the name of the original

Lewis

Thanks Lewis.

I actually already tried exactly what you suggested, but it didn't fix the problem.