View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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