2007: Property Sheet button disabled
 

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

Property Sheet button disabled
 

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

Tyro

"Richard H" wrote in message
...
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

Property Sheet button disabled
 

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.

"Tyro" wrote:

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

Tyro

"Richard H" wrote in message
...
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

2007: Property Sheet button disabled
 

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

"Richard H" wrote:

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

Property Sheet button disabled
 

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

"Richard H" wrote in message
...
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.

"Tyro" wrote:

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

Tyro

"Richard H" wrote in message
...
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

2007: Property Sheet button disabled
 

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.


Richard H wrote:

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

--

Dave Peterson