Toolbars in Excel 2007

[Doug Robbins - Word MVP]

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.

 

[Bob Phillips]

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.

 

[Peter T]

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

 

[Peter T]

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

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

 

[Bob Phillips]

It doesn't for me Peter (although I accept I may be attaching it
incompletely, I haven't done that for years).

--

HTH

Bob

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

 

[Doug Robbins - Word MVP]

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]

Building the toolbar at run-time avoids making that mistake