| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 crashes after viewing property sheet in Data Connection | New Users to Excel | |||
| make button invisible if macros disabled | Excel Discussion (Misc queries) | |||
| Why Undo and Redo button are disabled in my Pivot | Excel Discussion (Misc queries) | |||
| Insert Hyperlink button disabled in Excel | Excel Discussion (Misc queries) | |||
| Pivot Table toolbar - button always disabled | Excel Discussion (Misc queries) | |||
Linear Mode
