ExcelBanter - View Single Post

Bob Phillips

Modified by the comment in my signature.

--
---
HTH

Bob

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

"Chaplain Doug" wrote in message
...
Thanks Bob:

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

"Bob Phillips" wrote:

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)

"Chaplain Doug" wrote in message
...
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