What does this mean? "Can't execute code in design mode"
Try showing the Control toolbox toolbar.
In xl2003, View|Toolbars|Control Toolbox
There's an icon on that toolbar call Design mode. Does it look depressed (but
not sad!)?
If yes, click on it to leave design mode--it's toggles on/off.
Danni2004 wrote:
I sometimes work in manual calculation b/c of the size of my files. A few
weeks ago, I started get a Microsoft Visual Basic dialog box that pops up
every time I hit the F9 button (to force the cells to calculate) that says
"Can't execute code in design mode". The sheet will still complete its
calculations after I hit OK.
As far as I can remember, nothing has changed in Excel for me. Can anyone
shed any light on this issue?
Thanks,
Danni
--
Dave Peterson
|