2007: Property Sheet button disabled

[Richard H]

Is there a way to enable the property sheet button on the Quick Access
Toolbar ?

When I add it to the QAT it's disabled, and doesn't function.

Excel Options -> Customize -> Customize the Quick Access Toolbar

Commands Not In Ribbon -> Add -> Property Sheet -> OK

 

[Tyro]

You have to select a form control on the worksheet to enable the Property
Sheet button

Tyro

 

[Richard H]

But I'm not using VBA, I'm using my mouse.

There is no active Form Control in Excel outside of VBA that I'm aware of.

 

[Richard H]

Actually it appears that to activate the Properties dialog I need to use the
Properties command and not the Property Sheet command.

 

[Tyro]

You can put a form control or an active X control on your worksheet without
VBA. Excel 2007, Developer/Controls/Insert. I don't know where it is in
Excel 2003 but it's there. The Property Sheet is for the form controls.

Tyro

 

[Dave Peterson]

You could go to the developer tab and then click on the properties button in the
controls group.

But if you want, you can add "Control Properties" to the QAT.

I'm not positive that this is what you want, though.