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

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

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

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

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

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

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