xlb location

J

jejyjose

HOw do I know where excel is keeping it's toolbar files .xlb in system
via VBA or registry entry, etc
 
D

Dave Peterson

Just to add to Gord's reply.

If you find more than one *.xlb, go back to excel and make a small change.

close excel and repeat your search and pick off the most current.

For me (win98 and xl2002), it was:
C:\WINDOWS\Application Data\Microsoft\Excel\

This KB article has some more info:
http://support.microsoft.com/default.aspx?scid=kb;en-us;280659
XL2002: Custom Toolbars Missing After Upgrade from Earlier Version

But it could be almost anywhere:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;161235
XL97: How to Use a Toolbar Settings File from a Network Share
 
Top