Big problem at work-Runtime 57121

[mbb4331]

I am built a file that worked fine yesterday and I am getting "Application-defined or object-defined error" on anything I try to do this morning. I have two buttons on a sheet called "Control". If I click one to run:

thisworkbook.sheets("data").select

I get this error. All of this code was running fine yesterday. I have the following references:

Excel and Office 11.0 Libraries, Forms 2.0 Library, Visual Basic for Applications and OLE Automation.

I can run "thisworkbook.sheets(1).select", since it refers to the sheet with the button and code, but cannot run "thisworkbook.sheets(2).select"...

One other thing, I may have worked yesterday before saving, and once I saved and tried again today, it didn't.

Any ideas would be very appreciated...

 

[Andrew Poulsom]

If your button is from the Control Toolbox, try setting its TakeFocusOnClick property to False.

 

[mbb4331]

Thanks, but I deleted the sheet and re-created it and it works.

Somehow, either the sheet or the named range on the sheet became corrupted.