User controls on sheet question. - How to toggle between design and execute mode?

H

Hexman

I've added a command button on "Sheet1" of my workbook. Placed a bit
of code behind it. Now I want to get out of "Design" mode so I can
press the command button to see if the code works.

I'm sure there is an easy way to toggle between design and execute
modes, but darn, I can't seem to find it. I thought removing the
control tooldbox from the display would toggle it back to execute mode
but it doesn't.

The only way I've found to toggle is to save the spreadsheet, close
Excel and start it back up again. Please show me an easier way.

Thanks,

Hexman
 
H

Hexman

I've added a command button on "Sheet1" of my workbook. Placed a bit
of code behind it. Now I want to get out of "Design" mode so I can
press the command button to see if the code works.

I'm sure there is an easy way to toggle between design and execute
modes, but darn, I can't seem to find it. I thought removing the
control tooldbox from the display would toggle it back to execute mode
but it doesn't.

The only way I've found to toggle is to save the spreadsheet, close
Excel and start it back up again. Please show me an easier way.

Thanks,

Hexman
Click to expand...


I found it. It's the "Exit Design Mode" icon in the toolbox itself!

DUH!!!


Hexman
 

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

Documents from shared model are created with design mode on 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Toggle between Desin and Run mode 2
How to execute a command in VBA 2
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
Toggle Event - 2 Commands on 1 Button 1
Excel 2007 Design Mode 3
Command Button Question 8

Top