How to create "permanent" toolbars

[davegb]

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.

 

[Gord Dibben]

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

 

[davegb]

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



- 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.

 

[Gord Dibben]

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

 

[davegb]

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



- Show quoted text -

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