![]() |
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. |
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