Change Excel 2003 default toolbar path

C

Christmas May

I know how to change the Excel11.xlb file by copying and pasting into it's
default location. Is there a way/setting inside excel (tools/options) where
I can simply change the default path and leave the file in it's position,
simply change the path where Excel looks?

Thanks in advance,

Christmas May
 
P

Peter T

I don't think so, but why!

It's always worthwhile to maintain a backup of your custom xlb as
occasionally it can suddenly bloat enormously and slow things down. Even a
heavily customized xlb is unlikely to be larger than 50kb.

If you ever want to restore the default, close Excel, rename the custom xlb
and a new file will be created when you next open Excel.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I mass-change macro paths of tool buttons? 15
Remove add-in - also remove toolbar 6
Change location of XLSTART 2
Active or current file path 9
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
default file location in a file 2
Problem with default file path 6
excel toolbar won't save 3

Top