View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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