attach custom toolbar to spreadsheet: how?

[Bart Plessers \(artabel\)]

Hello,

For a client I have made some macro's to speed up things in a spreadsheet.
I have created a custom toolbar, and attached the macro's to newly created
buttons.
Then I attached the toolbar to the spreadsheet.

However,
If I open the spreadsheet on another workstation for the first time, the
toolbar is opened, but no button is defined on it. I have also troubles to
get my macro's starting on the workbook.

So my question is:
-how can I create a custom toolbar that is attached to a certain spreadsheet
-the toolbar should be opened automatically when the spreadsheet is opened
-the toolbar should be deleted if the spreadsheet is closed (toolbar
commands are NOT available to other spreadsheets)

Is this possible? How?

thanx in advance,

bart plessers

 

[Bart Plessers \(artabel\)]

VERY usefull links indeed!
thanx for response,

bart

 

[Bart Plessers \(artabel\)]

Just one more question:
do you know how to position the toolbar?
I recreate the toolbar everytime the workbook is opened with Autpen and
delete the toolbar with Auto_Close when the workbook is closed (are there
better ways to achieve this? I want to have the macro's invisible to the
user...)
When the toolbar is create, it appears 'somewhere' on the screen. Can I
position it somewhere by use of macro? Can I have it docked to the main menu
bar?

thanx in advance

regards,
bart