Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Excel 2003 toolbars in Excel 2007

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Virus wont let me run certain programs  
Author Message
Helge V. Larsen

External


Since: Mar 24, 2009
Posts: 2



(Msg. 1) Posted: Thu Sep 03, 2009 9:25 am
Post subject: Excel 2003 toolbars in Excel 2007
Archived from groups: microsoft>public>excel (more info?)
I have used Excel 2003 for years and have made a rather heavy customization
by defining new toolbars with buttons calling VBA. Unfortunately, with Excel
2007 toolbars no longer exist! Gates and his gang of developers have decided
that we all have to use Ribbon instead. Ofcourse I could write a lot of XML
using the Custom UI Editor
([URL="http://openxmldeveloper.org/articles...muieditor.aspx"]http://openxmldeveloper.org/articles...muieditor.aspx[/URL]) to put my
customization into the Ribbon - but I still prefer toolbars.

I know of two utilities that introduce toolbars in Excel 2007: ToolbarToggle
([URL="http://www.toolbartoggle.com"]http://www.toolbartoggle.com[/URL]) and Classic Menu for Excel 2007
([URL="http://www.addintools.com/english/menuexcel"]http://www.addintools.com/english/menuexcel[/URL]). As far as I can see, only
ToolbarToggle supports toolbar customization.

Does anyone know other - and perhaps better - toolbar utilities for Excel
2007?

(This has also been posted to [URL="http://www.mrexcel.com/forum"]http://www.mrexcel.com/forum[/URL] in forum 'Excel
Questions' and to [URL="http://www.excelforum.com"]http://www.excelforum.com[/URL] in forum 'Excel 2007 Help'.)

 >> Stay informed about: Excel 2003 toolbars in Excel 2007 
Back to top
Login to vote
Dave Peterson

External


Since: Oct 17, 2008
Posts: 38



(Msg. 2) Posted: Thu Sep 03, 2009 9:25 am
Post subject: Re: Excel 2003 toolbars in Excel 2007
Archived from groups: per prev. post (more info?)
I'm not sure how you create the new toolbars (via code or manually creating and
attaching them to workbooks???).

But I use code to create my toolbars. And when I do that, the toolbars show up
under the Addins tab on the xl2007 ribbon. (Someday, I'll bite the bullet and
create a ribbon version--real soon <vbg>.)

Here's how I do it when I want a toolbar:
[URL="http://www.contextures.com/xlToolbar02.html"]http://www.contextures.com/xlToolbar02.html[/URL]
(from Debra Dalgleish's site)

"Helge V. Larsen" wrote:
>
> I have used Excel 2003 for years and have made a rather heavy customization
> by defining new toolbars with buttons calling VBA. Unfortunately, with Excel
> 2007 toolbars no longer exist! Gates and his gang of developers have decided
> that we all have to use Ribbon instead. Ofcourse I could write a lot of XML
> using the Custom UI Editor
> ([URL="http://openxmldeveloper.org/articles...muieditor.aspx"]http://openxmldeveloper.org/articles...muieditor.aspx[/URL]) to put my
> customization into the Ribbon - but I still prefer toolbars.
>
> I know of two utilities that introduce toolbars in Excel 2007: ToolbarToggle
> ([URL="http://www.toolbartoggle.com"]http://www.toolbartoggle.com[/URL]) and Classic Menu for Excel 2007
> ([URL="http://www.addintools.com/english/menuexcel"]http://www.addintools.com/english/menuexcel[/URL]). As far as I can see, only
> ToolbarToggle supports toolbar customization.
>
> Does anyone know other - and perhaps better - toolbar utilities for Excel
> 2007?
>
> (This has also been posted to [URL="http://www.mrexcel.com/forum"]http://www.mrexcel.com/forum[/URL] in forum 'Excel
> Questions' and to [URL="http://www.excelforum.com"]http://www.excelforum.com[/URL] in forum 'Excel 2007 Help'.)

 >> Stay informed about: Excel 2003 toolbars in Excel 2007 
Back to top
Login to vote
Shane Devenshire

External


Since: Nov 13, 2008
Posts: 17



(Msg. 3) Posted: Thu Sep 03, 2009 9:25 am
Post subject: RE: Excel 2003 toolbars in Excel 2007
Archived from groups: per prev. post (more info?)
Here are some, I don't use them but...

Here are three sites where you can get downloads which basically give you a
classic menu/toolbar interface:

MenuExcel
[URL="http://www.addintools.com/english/menuexcel/"]http://www.addintools.com/english/menuexcel/[/URL]

Tooolbar Toggle
[URL="http://www.toolbartoggle.com"]http://www.toolbartoggle.com[/URL]

UBitMenu
[URL="http://www.ubit.ch/software/ubitmenu-languages/"]http://www.ubit.ch/software/ubitmenu-languages/[/URL]

and you can google for more.
 >> Stay informed about: Excel 2003 toolbars in Excel 2007 
Back to top
Login to vote
2007FanFoe

External


Since: Sep 3, 2009
Posts: 1



(Msg. 4) Posted: Thu Sep 03, 2009 10:34 pm
Post subject: Re: Excel 2003 toolbars in Excel 2007
Archived from groups: per prev. post (more info?)
Hi Helge,

You’ll find at least two or five products listed on Microsoft Office
Marketplace for each Office application if you search as:
For Access:
[URL="http://www.google.com/search?q=site:office.microsoft.com/en-us/marketplace/+EM102402711033+OR+EM102321611033&num=100&hl=EN&as_qdr=all&filter=0"]http://www.google.com/search?q=site:office.microsoft.com/en-us/marketplace/+EM102402711033+OR+EM102321611033&num=100&hl=EN&as_qdr=all&filter=0[/URL]
For Excel:
[URL="http://www.google.com/search?q=site:office.microsoft.com/en-us/marketplace/+EM102325091033+OR+EM102220651033+OR+EM102321621033+OR+EM102674421033&num=100&hl=EN&as_qdr=all&filter=0"]http://www.google.com/search?q=site:office.microsoft.com/en-us/marketplace/+EM102325091033+OR+EM102220651033+OR+EM102321621033+OR+EM102674421033&num=100&hl=EN&as_qdr=all&filter=0[/URL]
For PowerPoint:
[URL="http://www.google.com/search?q=site:office.microsoft.com/en-us/marketplace/+EM102325091033+OR+EM102220671033+OR+EM102321631033&num=100&hl=EN&as_qdr=all&filter=0"]http://www.google.com/search?q=site:office.microsoft.com/en-us/marketplace/+EM102325091033+OR+EM102220671033+OR+EM102321631033&num=100&hl=EN&as_qdr=all&filter=0[/URL]
For Word:
[URL="http://www.google.com/search?q=site:office.microsoft.com/en-us/marketplace/+EM102325091033+OR+EM102220681033+OR+EM102321641033&num=100&hl=EN&as_qdr=all&filter=0"]http://www.google.com/search?q=site:office.microsoft.com/en-us/marketplace/+EM102325091033+OR+EM102220681033+OR+EM102321641033&num=100&hl=EN&as_qdr=all&filter=0[/URL]

Regards,

Fanfoe


On Sep 3, 9:31 am, "Helge V. Larsen"
wrote:
> I have used Excel 2003 for years and have made a rather heavy customization
> by defining new toolbars with buttons calling VBA. Unfortunately, with Excel
> 2007 toolbars no longer exist! Gates and his gang of developers have decided
> that we all have to use Ribbon instead. Ofcourse I could write a lot of XML
> using the Custom UI Editor
> ([URL="http://openxmldeveloper.org/articles...muieditor.aspx"]http://openxmldeveloper.org/articles...muieditor.aspx[/URL]) to put my
> customization into the Ribbon - but I still prefer toolbars.
>
> I know of two utilities that introduce toolbars in Excel 2007: ToolbarToggle
> ([URL="http://www.toolbartoggle.com"]http://www.toolbartoggle.com[/URL]) and Classic Menu for Excel 2007
> ([URL="http://www.addintools.com/english/menuexcel"]http://www.addintools.com/english/menuexcel[/URL]). As far as I can see, only
> ToolbarToggle supports toolbar customization.
>
> Does anyone know other - and perhaps better - toolbar utilities for Excel
> 2007?
>
> (This has also been posted to[URL="http://www.mrexcel.com/forumin"]http://www.mrexcel.com/forumin[/URL] forum 'Excel
> Questions' and to[URL="http://www.excelforum.comin"]http://www.excelforum.comin[/URL] forum 'Excel 2007 Help'.)
 >> Stay informed about: Excel 2003 toolbars in Excel 2007 
Back to top
Login to vote
Helge V. Larsen

External


Since: Mar 24, 2009
Posts: 2



(Msg. 5) Posted: Fri Sep 04, 2009 7:25 am
Post subject: Re: Excel 2003 toolbars in Excel 2007
Archived from groups: per prev. post (more info?)
After comparing the tools mentioned in my original post and in posts from
Dave Peterson, Shane Devenshire and 2007FanFoe (thanks to all) I think that
ToolbarToggle is best suited for me:
It does NOT integrate 2003-toolbars into the 2007-Ribbon. Instead
ToolbarToggle creates its own menu bar and toolbars.
The user can have Ribbon or toolbars or both displayed - and most important
to me: ToolbarToggle's menus and toolbars can be customized calling my own
VBA.


"Helge V. Larsen" wrote in
message
>I have used Excel 2003 for years and have made a rather heavy customization
>by defining new toolbars with buttons calling VBA. Unfortunately, with
>Excel 2007 toolbars no longer exist! Gates and his gang of developers have
>decided that we all have to use Ribbon instead. Ofcourse I could write a
>lot of XML using the Custom UI Editor
>([URL="http://openxmldeveloper.org/articles...muieditor.aspx"]http://openxmldeveloper.org/articles...muieditor.aspx[/URL]) to put my
>customization into the Ribbon - but I still prefer toolbars.
>
> I know of two utilities that introduce toolbars in Excel 2007:
> ToolbarToggle ([URL="http://www.toolbartoggle.com"]http://www.toolbartoggle.com[/URL]) and Classic Menu for Excel
> 2007 ([URL="http://www.addintools.com/english/menuexcel"]http://www.addintools.com/english/menuexcel[/URL]). As far as I can see,
> only ToolbarToggle supports toolbar customization.
>
> Does anyone know other - and perhaps better - toolbar utilities for Excel
> 2007?
>
> (This has also been posted to [URL="http://www.mrexcel.com/forum"]http://www.mrexcel.com/forum[/URL] in forum 'Excel
> Questions' and to [URL="http://www.excelforum.com"]http://www.excelforum.com[/URL] in forum 'Excel 2007 Help'.)
>
>
 >> Stay informed about: Excel 2003 toolbars in Excel 2007 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Unable to open excel 2007 file in excel 2002 despite havin.. - Hi I have installed office compatibility pack for office 2007. However, every time I try to open an xlsx file, I get unrecognized format error in Excel 2002. I can open docx without an issue. It appears to be that the problem is related specifically....

Excel 2003 documents migration to 2007 - Hello Excel Mania.... :) I have project to convert a lot of Excel 2003 documents to Excel 2007, including its macro and chart. After I surfed some website which mostly got explanation about changes between thoose version, I hardly find a complete..

Excel 2003 - VBA - .copy - I want to copy a range from one page to another. I seem that I have to have the sheet that I am copying from as the activesheet. Sheets("Display").Select Sheets("PPO").Range(Cells(3, 2), Cells(3, NumSym + 1)).Copy Sheets(...

Lotus 1-2-3 file with Excel 2003 - We could always open Lotus 1-2-3 file with Excel 2003. However, now I get a message saying " You are attempting to open a file type that is blocked by your registry policy settings." Microsoft's solution..

EXCEL 2003 paste special and go to specil misfunction - Hello to everybody, I noticed that if I use the "paste special - values" function to, say, paste three cells with a formula behind and just one value displaying, your result would be to obtain two blank cells and a cell with a value on it. Th...
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]