Excel 2007. I have posted this problem a couple times now. Would anyone be
willing to let me send a copy of the workbook that is bombing in Excel 2007
to see if you can reproduce the problem and/or give me help in finding the
solution?

I have a workbook with lots of code that has worked great for years with
Excel 2003. Now with Excel 2007 I am getting the following error on a
control that exists on an activated, unprotected sheet in an unprotected
workbook.

I am getting the following error on this line of code:

ThisWorkbook.Sheets("Main Menu").PayrollCompare.Enabled = True


Run-time error '1004'

Unable to set the enabled property of the OLEObject class.


This is happening in my Workbook_Open event module. Would anyone be willing
to help? Thanks.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org