Excel customized tolbar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Information - 15 Feb 2006 21:12 GMT

We havea copy of Excel 97 that has some customized buttons on the standard
toolbar.

How can we move these into Excel 2000? We have two other machines that
would benefit from these.

Thanks in advance,

Dan

Reply to this Message

Dave Peterson - 15 Feb 2006 21:23 GMT

Toolbars aren't always compatible between versions.

I don't think I'd try it.

But if you print screen showing the icons you like, you can create a new toolbar
in the newer version and just recreate it once. Then copy from that pc to the
others.

ps. This might not work--it depends on what those customized buttons do.

> We havea copy of Excel 97 that has some customized buttons on the standard
> toolbar.
[quoted text clipped - 5 lines]
>
> Dan

Signature

Dave Peterson

Reply to this Message

Information - 15 Feb 2006 21:46 GMT

I believe most of the buttons just reposition you to an absolute cell. The
form is a quote, and the buttons move you to specific locations in the
quote.

I should just dig a little deeper and create new in the newer version.

> Toolbars aren't always compatible between versions.
>
[quoted text clipped - 18 lines]
>>
>> Dan

Reply to this Message

Dave Peterson - 16 Feb 2006 00:34 GMT

I find it much easier to just create the toolbar when the workbook opens.

If you're going to invest time in recreating your toolbar, you may want to try
this instead.

I really like the way John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

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

> I believe most of the buttons just reposition you to an absolute cell. The
> form is a quote, and the buttons move you to specific locations in the
[quoted text clipped - 28 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

David McRitchie - 16 Feb 2006 18:31 GMT

Hi Dan,
Between different versions of Excel you would have to copy your tool bar buttons

The first thing I would suggest is to print your toolbars something you want to compare
back to anyway. You might print your desktop as well as things there tend to get moved
around without your help.

Next copy each customized button from the toolbar to a worksheet so that you have the button
images available to copy from when you open that workbook in your new version. For myself
I already had my buttons documented on my toolbars page...

In the new version when you rebuild your menus and toolbars you can copy the
button images from your worksheet and use then with your tool bar button definitions.(paste image).

A couple of pages you might want to look at are
Toolbars, Custom Buttons and Menus
. http://www.mvps.org/dmcritchie/excel/toolbars.htm
and
Barhopper -- fixup for Restored Toolbars, and -- Listing of Menu Items
http://www.mvps.org/dmcritchie/excel/barhopper.htm

You already have suggestions to add and delete toolbars on the fly in the future.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Reply to this Message