Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does this mean? "Can't execute code in design mode"
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does this mean? "Can't execute code in design mode"
Does it look depressed (but not sad!)?
LOL! -- Biff Microsoft Excel MVP "Dave Peterson" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does this mean? "Can't execute code in design mode"
Do you have any code designed to run at the Calculate event. To check this
right click on the XL icon next to File in the Excel menu and select View Code. Look for a sub that starts like this... Private Sub Workbook_SheetCalculate(ByVal Sh As Object) If there is nothing like that then you need to select each sheet from the project explorer (in the VBE hit Ctrl + R to bring up the explorer) by doubleclicking the sheet. You are looking for code starting with... Private Sub Worksheet_Calculate() If you have any code like that then this is the culpret. Your sheet is in design mode and your macros can't execute. To get your book out of design mode bring up the Control Toolbox or the Visual Basic Toolbar and click the icon that looks like a triangle and ruler. -- HTH... Jim Thomlinson "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does this mean? "Can't execute code in design mode"
Thanks. (One of my personal favorites!)
"T. Valko" wrote: Does it look depressed (but not sad!)? LOL! -- Biff Microsoft Excel MVP "Dave Peterson" wrote in message ... 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I turn on/off "Design mode" in Excel 2007 | Excel Discussion (Misc queries) | |||
Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
Error Msg "Can't Exit Design Mode" | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) |