Turning Design Mode On/Off

  • Thread starter Thread starter pikus
  • Start date Start date
P

pikus

How do I turn Excel's Design Mode on or off using VBA? I'm stumped!
Piku
 
Pikus,

I seriously doubt this is possible. Reason being that the
definition of design mode is: "Design mode is the time
during which no code from the project is running and
events from the host or project will not execute."

But then, why would you want to? You can alter the design
of objects at run time anyway. Unless you were in design
mode when you started running the code?

Steven D
 
I was trying to use "FillDown" to copy CheckBoxes. I know this is no
the only way to do this, but I was hoping it might be that easy.
Piku
 
Design mode wouldn't make a difference or be required.

No, you can't filldown objects.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Design Mode switching is not working 4
Design Mode 2
Msgbox in worksheet activate event if design mode is turned off 6
turn off design mode 2
unwanted design mode during macro exection 2
Create listbox with code but can't select any items in list box 6
Monitor displays AGING mode 1
XL2003: Toggling "Extend" Mode with VBA 1

Back
Top