I was just upgraded from Office 2000 to Office 2003 here at work. (I
know, this is the state!) In XL2000, I could create tools and put them
on the standard toolbar permanently, but I can't seem to do this with
XL2003. I think it's because it now longer calls for the "PERSONAL"
workbook where all the macros behind the buttons lived. Is there a
workaround for this? If I can't get the tools in the existing
toolbars, can I make a custom toolbar that automatically comes up when
I open XL?
Thanks again.

Put your macros in a new workbook.

Use code to create the toolbar when that workbook opens.

Save the workbook as an add-in and load through Tools>Add-ins.

For code to create a Toolbar see Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar02.html

John Walkenbach's menumaker workbook is also a good source for creating
toolbars.

http://j-walk.com/ss/excel/tips/tip53.htm


Gord Dibben MS Excel MVP

On Mon, 29 Dec 2008 07:50:03 -0800 (PST), davegb <(E-Mail Removed)>
wrote:

>I was just upgraded from Office 2000 to Office 2003 here at work. (I
>know, this is the state!) In XL2000, I could create tools and put them
>on the standard toolbar permanently, but I can't seem to do this with
>XL2003. I think it's because it now longer calls for the "PERSONAL"
>workbook where all the macros behind the buttons lived. Is there a
>workaround for this? If I can't get the tools in the existing
>toolbars, can I make a custom toolbar that automatically comes up when
>I open XL?
>Thanks again.

On Dec 29, 9:17*am, Gord Dibben <gorddibbATshawDOTca> wrote:
> Put your macros in a new workbook.
>
> Use code to create the toolbar when that workbook opens.
>
> Save the workbook as an add-in and load through Tools>Add-ins.
>
> For code to create a Toolbar see Debra Dalgleish's site.
>
> http://www.contextures.on.ca/xlToolbar02.html
>
> John Walkenbach's menumaker workbook is also a good source for creating
> toolbars.
>
> http://j-walk.com/ss/excel/tips/tip53.htm
>
> Gord Dibben *MS Excel MVP
>
> On Mon, 29 Dec 2008 07:50:03 -0800 (PST), davegb <daveg...@comcast.net>
> wrote:
>
>
>
> >I was just upgraded from Office 2000 to Office 2003 here at work. (I
> >know, this is the state!) In XL2000, I could create tools and put them
> >on the standard toolbar permanently, but I can't seem to do this with
> >XL2003. I think it's because it now longer calls for the "PERSONAL"
> >workbook where all the macros behind the buttons lived. Is there a
> >workaround for this? If I can't get the tools in the existing
> >toolbars, can I make a custom toolbar that automatically comes up when
> >I open XL?
> >Thanks again.- Hide quoted text -
>
> - Show quoted text -

Thanks for the reply. They've sure figured out how to make it way more
complicated, haven't they? Another M$ dehancement to Office 2003!
Happy Holidays.

Actually you can have a Personal.xls in 2003 and add buttons to the Toolbar.

These customizations are saved in your Excel11.xlb file.

I don't recommend going with that method due to a larger *.xlb file tending
to become corrupt and cause problems.

But you can still do it the way you did in Excel 2000 if you choose.


Gord

On Mon, 29 Dec 2008 12:28:24 -0800 (PST), davegb <(E-Mail Removed)>
wrote:

>Thanks for the reply. They've sure figured out how to make it way more
>complicated, haven't they? Another M$ dehancement to Office 2003!
>Happy Holidays.

On Dec 29, 8:00*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> Actually you can have a Personal.xls in 2003 and add buttons to the Toolbar.
>
> These customizations are saved in your Excel11.xlb file.
>
> I don't recommend going with that method due to a larger *.xlb file tending
> to become corrupt and cause problems.
>
> But you can still do it the way you did in Excel 2000 if you choose.
>
> Gord
>
> On Mon, 29 Dec 2008 12:28:24 -0800 (PST), davegb <daveg...@comcast.net>
> wrote:
>
>
>
> >Thanks for the reply. They've sure figured out how to make it way more
> >complicated, haven't they? Another M$ dehancement to Office 2003!
> >Happy Holidays.- Hide quoted text -
>
> - Show quoted text -

Thanks again, Gord. Think I'll do the extra steps and avoid the
hassles later on.

On Mon, 29 Dec 2008 19:00:24 -0800, Gord Dibben wrote:

> Actually you can have a Personal.xls in 2003 and add buttons to the Toolbar.
>
> These customizations are saved in your Excel11.xlb file.
>
> I don't recommend going with that method due to a larger *.xlb file tending
> to become corrupt and cause problems.
>
> But you can still do it the way you did in Excel 2000 if you choose.
>
>
> Gord
>
> On Mon, 29 Dec 2008 12:28:24 -0800 (PST), davegb <(E-Mail Removed)>
> wrote:
>
>>Thanks for the reply. They've sure figured out how to make it way more
>>complicated, haven't they? Another M$ dehancement to Office 2003!
>>Happy Holidays.

Just to let you know, I finally got time to get to this and it worked fine.
Made some mods to put the toolbar up adjacent to the formatting toolbar and
also to get rid of that annoying "Reviewing" toolbar that XP wants up all
the time.

Thanks!