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

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.

"Chaplain Doug" wrote:

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

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

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

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