Excel 2007 Problem

[Guest]

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.

 

[Guest]

trying moving the workbook(s) to a directory that you have full privilde. It
may be a problem with the protection on the files and not excel.

 

[Bob Phillips]

You could send it me Doug if you wish.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Bob:

To what addy can I send it?
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

You could send it me Doug if you wish.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

Modified (e-mail address removed) by the comment in my signature.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Thanks Bob:

To what addy can I send it?