View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
B Nieds B Nieds is offline
external usenet poster
 
Posts: 5
Default Execl Toolbars update

Thanks for the reply.

There are several custom buttons created over the years on different
toolbars. If I can at least get a listing of all the custom buttons then
I would not have to guess if I found them all. This information has to
be store somewhere.

Thanks
Bill

Dave Peterson wrote:
I wouldn't do it.

But if I had the pc with xl97 still available, I'd do this:
Open Excel on that pc
Make note of all the icons/modifications on the toolbar

Use those notes to create a new toolbar on the pc with xl2002.

You may find that when you rebuild the toolbar, there'll be icons that are never
used and don't need to be added.

And when you're building that toolbar searching for the icons you like, you'll
see all the new features that can be added to toolbar.

But when the toolbar is built the way you like, make a copy of it and store it
in a safe location. You never know when something bad will happen--either on
purpose or by accident.

And by keeping a backup version, it'll be really fast to put the toolbar back
the way you like.

B Nieds wrote:

Hi:

My in-laws have decided it was time to upgrade to a new computer (used
but new to them) and now have Window XP with MS Office 2002. They were
using Office 97 so this is quite a step up for them.

They use Excel and Word primarily and to make their life easier I have
created (in Excel 97) several custom button (with macros) on several
Toolbars.

My question is: Where is the information on the Toolbars stored in Excel
97 and can I copy this information over to Excel 2002?

Thanks
Bill