The designed mode in Microsoft Excel is grayed out

[Jigisha]

I can not figure out why this designed mode button in Microsoft Excel is greyed out. I have looked all over the web and there could be simple solutions for same. If anyone has any advice why my design mode button is greyed out then please let me know. Thanks

[Shurod]

Design mode is greyed out when you do not have anything on the worksheet for which you can use design mode. Create a control button or combobox or something and it will be enabled. In fact, it turns on by default when you create the object so you can continue with the design and you have to turn it off before you can use the object.

[Panop]

Are you using Office 2007 version. If so, I notice that mine's greyed out too until I click either the View Code or Properties buttons. Of course, if you have inserted a form or Active X Control, then the Design button should not be greyed out. Office 2007 doesn't seem to behave in the same manner for all people, so you may have to find your own way to wake it up.

[Shurod]

Yeah....that's how it's supposed to work!! But Offce 2007 is rather sluggish and slow to react, in fact it may need a nudge like I explained in my earlier reply.