2007: Property Sheet button disabled

R

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
 
R

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.
 
R

Richard H

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

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
 
D

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.
 

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

Top