On the Excel Ribbon and the VBA-editor I can activate the so called "Design Mode". As far as I understand the only thing "design mode" does is to "deactivate" all userform elements on the worksheets so a left click only selects them instead of triggering their events.
Is there anything else "Design Mode" does when it's turned on in regards to when it's turned off (particular within the VBA-editor)?
EDIT: Note, quite a few article say I can not run code wihle in design mode, which is only partly true. As far as I see e.g. macros can not be executed by command buttons etc. that are placed on the worksheet (as I explained in my question), but code can be started via keyboard shortcuts, VBA-editor etc. without explicitly ending design mode.
1 Answer
Design Mode contradicts run/debug mode.
In Design Mode you cannot use the debugging tools, except for setting breakpoints and creating watch expressions.
When you Run the VBA code, you in effect exit from Design Mode.
See Visual Basic Concepts - Design Time, Run Time, and Break Mode.
10
