Error - can't exit design mode

[JT]

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.
...

 

[Matt Lavery]

JT:

Upgrading to 2003 resets your Macro Security Level. Try going to
Tools:Macro...:Security... and reset your security level to Medium or Low.

---

- Matt Lavery

You are responsible for everything you think, say, do, feel and believe.
That is all you are responsible for, and you are the only one responsible for
it.