I'm migrating my Excel 2003 VBA add-in to Excel 2007 and am having a little
trouble with Excel's Design Mode:

First, I can't manually get Excel 2007 into design mode. I go to the
Developer tab and insert a command button onto the active worksheet. If I
then click the Design Mode button on the ribbon and then try to select the
just inserted command button, Excel tries to run the OnAction macro. I can
keep on clicking the Design Mode button and it doesn't do any good.

Second, my add-in contains code to put Excel into and out of Design Mode.
I've tried the previously published techniques (e.g.,
Application.CommandBars.FindControl(ID:=1605).Exec ute or
Application.CommandBars("Control Toolbox").Controls("&Design Mode").
Execute) and neither of them work.

Anybody got any ideas?

TIA,

josh