G Guest Jun 13, 2005 #1 I have my Excel toolbars just the way I like it and I was wondering if there was a way to share the toolbar with another user?
I have my Excel toolbars just the way I like it and I was wondering if there was a way to share the toolbar with another user?
G Gord Dibben Jun 13, 2005 #2 Tasha Menu and Toolbar customizations are stored in your *.XLB file. Version 97 is username.xlb and found in C:\Windows folder. Versions 2000 through 2003 are Excel9, Excel10 and Excel11.xlb and would be found in Documents and Settings\yourname\application data\microsoft\Excel One method is to send your *.XLB file to the other user and have that user overwrite their own *.xlb with yours. Another method is to Attach the Toolbar(Tools>Customize>Toolbars) to a file and send that file. Gord Dibben Excel MVP
Tasha Menu and Toolbar customizations are stored in your *.XLB file. Version 97 is username.xlb and found in C:\Windows folder. Versions 2000 through 2003 are Excel9, Excel10 and Excel11.xlb and would be found in Documents and Settings\yourname\application data\microsoft\Excel One method is to send your *.XLB file to the other user and have that user overwrite their own *.xlb with yours. Another method is to Attach the Toolbar(Tools>Customize>Toolbars) to a file and send that file. Gord Dibben Excel MVP