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

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

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

On Wed, 21 Dec 2005 16:53:23 -0800, Hexman wrote:

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


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

DUH!!!


Hexman