What does attaching a toolbar to a spreadsheet do?

K

kgm200

I have created a custom toolbar which I'd like to use on approximately 30
spreadsheet. Everytime I assign macros to the toolbar buttons it uses the
macros from the latest assgned spreadsheet. How do I assign a toolbar in a
one to one relationship to a spreadsheet?
 
R

Ron de Bruin

Hi

Example from JKP
*****************

About toolbars:

You can attach a toolbar to a workbook. When this workbook is loaded, XL checks if the toolbar is on the system.
If not, it copies the toolbar from the workbook to the system.

After creating *or changing* the toolbar, you should attach the toolbar to your workbook:

- activate the workbook to which you want to attach the toolbar
- Rightclick the toolbar, select 'customize'
- Click 'Attach' (Toolbars Tab)
- If the workbook already contains a toolbar by that name, delete it first by clicking on it on the righthand side and choosing
Delete.
- Select your toolbar (on the left) and press 'copy'
- Save the workbook (optionally: save_as an add-in).
 
Top