copying Custom Toolbars in Excel

  pcmadness 10:31 24 Oct 2004
Locked

can anyone tell me if there is a simple way to copy a custom tool bar in excel from one pc to another. To save starting fron scratch on each machine.???? Same goes for macros

  VoG II 10:37 24 Oct 2004

Macros - in the Visual Basic Editor (Alt+F11 to get into the VBE) File/Export and this will save the macro module you are viewing as a .bas file.

On the other machine you can then use a similar procedure (File/Import) to insert the macro(s).

  VoG II 10:41 24 Oct 2004

Toolbars - will be saved with the extension .xlb

Do a search and copy them across. N.B. The same version of Excel must be on both machines.

  pcmadness 11:11 24 Oct 2004

Thanks - I copied across OK (same version) but whilst the come up if double click the .xlb file they do not open when I open the excel program. Nearly there. Got any ideas?

  pcmadness 13:30 24 Oct 2004

done it sorted I was using a wrong file
Thanks for the help
PCMadness

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?