Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars in Excel 2007
In Word 2007, if a Word 2003 document/template that contains a custom
toolbar is opened, the buttons from the toolbar appear under the Add-ins tab. The same does not appear to be the case in Excel. Is therefore adding macros to the QAT or Customizing the Ribbon the only option with Excel 2007? If that is the case, and it is going to be necessary to modify a template one way or the other for use in Excel 2007, I might as well Customize the Ribbon due to the limited choice of icons for the QAT. -- Thanks, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars in Excel 2007
No, if you create a workbook, either a standard workbook or an addin, which
builds a customised menu or toolbar via VBA, this will open up in the Addins tab. -- HTH Bob "Doug Robbins - Word MVP" wrote in message ... In Word 2007, if a Word 2003 document/template that contains a custom toolbar is opened, the buttons from the toolbar appear under the Add-ins tab. The same does not appear to be the case in Excel. Is therefore adding macros to the QAT or Customizing the Ribbon the only option with Excel 2007? If that is the case, and it is going to be necessary to modify a template one way or the other for use in Excel 2007, I might as well Customize the Ribbon due to the limited choice of icons for the QAT. -- Thanks, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars in Excel 2007
It *should* indeed appear in the Addins tab.
I just tested with an "attached" toolbar, which I never use. Even that appeared in Add-ins/"Custom Toolbars" together its button equivalents (without it being created or made visible in the open event). Are you sure the custom toolbar had been attached to the workbook. Regards, Peter T "Doug Robbins - Word MVP" wrote in message ... In Word 2007, if a Word 2003 document/template that contains a custom toolbar is opened, the buttons from the toolbar appear under the Add-ins tab. The same does not appear to be the case in Excel. Is therefore adding macros to the QAT or Customizing the Ribbon the only option with Excel 2007? If that is the case, and it is going to be necessary to modify a template one way or the other for use in Excel 2007, I might as well Customize the Ribbon due to the limited choice of icons for the QAT. -- Thanks, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars in Excel 2007
Seeing Bob's response made me double check, definitely the attached bar
appears in the addins tab without running any VBA at all. However, pressing the button I get the message 'Book1.htm' could not be found. Strange, the onAction had been correctly applied, even explicitly to workbook name. No idea where "Book1.HTM" comes from. Running a bit of code only to reapply the onAction then gets everything working. Peter T "Peter T" <peter_t@discussions wrote in message ... It *should* indeed appear in the Addins tab. I just tested with an "attached" toolbar, which I never use. Even that appeared in Add-ins/"Custom Toolbars" together its button equivalents (without it being created or made visible in the open event). Are you sure the custom toolbar had been attached to the workbook. Regards, Peter T "Doug Robbins - Word MVP" wrote in message ... In Word 2007, if a Word 2003 document/template that contains a custom toolbar is opened, the buttons from the toolbar appear under the Add-ins tab. The same does not appear to be the case in Excel. Is therefore adding macros to the QAT or Customizing the Ribbon the only option with Excel 2007? If that is the case, and it is going to be necessary to modify a template one way or the other for use in Excel 2007, I might as well Customize the Ribbon due to the limited choice of icons for the QAT. -- Thanks, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars in Excel 2007
It doesn't for me Peter (although I accept I may be attaching it
incompletely, I haven't done that for years). -- HTH Bob "Peter T" <peter_t@discussions wrote in message ... Seeing Bob's response made me double check, definitely the attached bar appears in the addins tab without running any VBA at all. However, pressing the button I get the message 'Book1.htm' could not be found. Strange, the onAction had been correctly applied, even explicitly to workbook name. No idea where "Book1.HTM" comes from. Running a bit of code only to reapply the onAction then gets everything working. Peter T "Peter T" <peter_t@discussions wrote in message ... It *should* indeed appear in the Addins tab. I just tested with an "attached" toolbar, which I never use. Even that appeared in Add-ins/"Custom Toolbars" together its button equivalents (without it being created or made visible in the open event). Are you sure the custom toolbar had been attached to the workbook. Regards, Peter T "Doug Robbins - Word MVP" wrote in message ... In Word 2007, if a Word 2003 document/template that contains a custom toolbar is opened, the buttons from the toolbar appear under the Add-ins tab. The same does not appear to be the case in Excel. Is therefore adding macros to the QAT or Customizing the Ribbon the only option with Excel 2007? If that is the case, and it is going to be necessary to modify a template one way or the other for use in Excel 2007, I might as well Customize the Ribbon due to the limited choice of icons for the QAT. -- Thanks, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars in Excel 2007
Thanks, Peter and Bob.
I now realise that the toolbar was not attached to the template. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Bob Phillips" wrote in message ... It doesn't for me Peter (although I accept I may be attaching it incompletely, I haven't done that for years). -- HTH Bob "Peter T" <peter_t@discussions wrote in message ... Seeing Bob's response made me double check, definitely the attached bar appears in the addins tab without running any VBA at all. However, pressing the button I get the message 'Book1.htm' could not be found. Strange, the onAction had been correctly applied, even explicitly to workbook name. No idea where "Book1.HTM" comes from. Running a bit of code only to reapply the onAction then gets everything working. Peter T "Peter T" <peter_t@discussions wrote in message ... It *should* indeed appear in the Addins tab. I just tested with an "attached" toolbar, which I never use. Even that appeared in Add-ins/"Custom Toolbars" together its button equivalents (without it being created or made visible in the open event). Are you sure the custom toolbar had been attached to the workbook. Regards, Peter T "Doug Robbins - Word MVP" wrote in message ... In Word 2007, if a Word 2003 document/template that contains a custom toolbar is opened, the buttons from the toolbar appear under the Add-ins tab. The same does not appear to be the case in Excel. Is therefore adding macros to the QAT or Customizing the Ribbon the only option with Excel 2007? If that is the case, and it is going to be necessary to modify a template one way or the other for use in Excel 2007, I might as well Customize the Ribbon due to the limited choice of icons for the QAT. -- Thanks, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars in Excel 2007
Building the toolbar at run-time avoids making that mistake :-)
-- HTH Bob "Doug Robbins - Word MVP" wrote in message ... Thanks, Peter and Bob. I now realise that the toolbar was not attached to the template. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Bob Phillips" wrote in message ... It doesn't for me Peter (although I accept I may be attaching it incompletely, I haven't done that for years). -- HTH Bob "Peter T" <peter_t@discussions wrote in message ... Seeing Bob's response made me double check, definitely the attached bar appears in the addins tab without running any VBA at all. However, pressing the button I get the message 'Book1.htm' could not be found. Strange, the onAction had been correctly applied, even explicitly to workbook name. No idea where "Book1.HTM" comes from. Running a bit of code only to reapply the onAction then gets everything working. Peter T "Peter T" <peter_t@discussions wrote in message ... It *should* indeed appear in the Addins tab. I just tested with an "attached" toolbar, which I never use. Even that appeared in Add-ins/"Custom Toolbars" together its button equivalents (without it being created or made visible in the open event). Are you sure the custom toolbar had been attached to the workbook. Regards, Peter T "Doug Robbins - Word MVP" wrote in message ... In Word 2007, if a Word 2003 document/template that contains a custom toolbar is opened, the buttons from the toolbar appear under the Add-ins tab. The same does not appear to be the case in Excel. Is therefore adding macros to the QAT or Customizing the Ribbon the only option with Excel 2007? If that is the case, and it is going to be necessary to modify a template one way or the other for use in Excel 2007, I might as well Customize the Ribbon due to the limited choice of icons for the QAT. -- Thanks, Doug Robbins - Word MVP, originally posted via msnews.microsoft.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 and 2003 Toolbars | Excel Programming | |||
Custom Toolbars in Excel 2007 | Excel Programming | |||
Toolbars placing at excel 2007 | Excel Discussion (Misc queries) | |||
order of toolbars in Excel 2007 | Excel Programming | |||
Custom Toolbars (Ribbons?) for Excel 2007 | Excel Discussion (Misc queries) |