ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with an error (https://www.excelbanter.com/excel-programming/316493-help-error.html)

JT[_2_]

Help with an error
 
I have a macro that I have been using for several months
without any problems. This morning Office 2003 was
installed on my machine and the macro doesn't work.

The error message is "Can't exit design mode because
control can't be created.

If I look at the Visual Basic Toolbar in Excel,
the "Design Mode" icon is depressed. However, I can't
press this button or I get the same error message.

If I open Excel, the "Design Mode" button is not
depressed. But if I open the macro, the this button gets
pressed.

Somewhere in the macro, it appears to press this button.
This didn't happen until we got the Office 2003 version
this morning.

If I open the macro on a machine with Office 2000 or 2002,
I do not have any issues with the macro.

Any suggestions would be greatly appreciated. Thanks for
the help.

Dave Peterson[_5_]

Help with an error
 
I don't use xl2003 and have never seen this error.

But lots of times, when you upgrade security settings get changed.

Maybe a visit to tools|macro|security|security level tab to ensure it's not High
is in order.

(I've seen that design mode icon depressed (even suicidal) when I've opened a
workbook with macros disabled--but I don't recall seeing the message.)

JT wrote:

I have a macro that I have been using for several months
without any problems. This morning Office 2003 was
installed on my machine and the macro doesn't work.

The error message is "Can't exit design mode because
control can't be created.

If I look at the Visual Basic Toolbar in Excel,
the "Design Mode" icon is depressed. However, I can't
press this button or I get the same error message.

If I open Excel, the "Design Mode" button is not
depressed. But if I open the macro, the this button gets
pressed.

Somewhere in the macro, it appears to press this button.
This didn't happen until we got the Office 2003 version
this morning.

If I open the macro on a machine with Office 2000 or 2002,
I do not have any issues with the macro.

Any suggestions would be greatly appreciated. Thanks for
the help.


--

Dave Peterson


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com