Solved

Tool Bar not going with workbook

Posted on 2011-03-16
3
253 Views
Last Modified: 2012-05-11
excel 2003...

I created  a custom Toolbar for a workbook.

I gave the workbook to a collegue ut he does not have the Tool bar ? or/ command bar

did I miss something...in giving him the workbook...?


Thanks
fordraiders
0
Comment
Question by:fordraiders
3 Comments
 
LVL 19

Accepted Solution

by:
akoster earned 500 total points
ID: 35148057
It depends,

normally a custom toolbar is saved in a file Excel.xlb (somewhere in your user profile)

If you follow the steps in

http://www.ozgrid.com/Excel/custom-toolbar.htm

you will be able to attach the toolbar to your workbook.
0
 
LVL 10

Expert Comment

by:borgunit
ID: 35148072
Something I wrote for myself once upon a time...

Copying Custom Toolbar Icons
If you've created these custom button icons using the Button Editor then I believe they get saved to a file named excelXX.xlb (as well as any other customizations you've made to your excel toolbars) that should be located in the folders below based on your OS:

For Windows 2000, XP they can be found in:
C:\Documents and Settings\(user ID)\Application Data\Microsoft\Excel

Just copy the file to the same location on another computer.
0
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 35148459
thankjs
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now