Open and close custom toolbar on startup/exit

[erikhs]

Hi,

This might have been answered in another thread, but i couldn't find it.
What do i need to do to open a custom toolbar when workbook opens, and close it when workbook close.
Do i need to add AutoExec, AutoExit procedures?
How do i "get" the toolbar?

Thanks!

[dominicb]

Good afternoon erikhs

There are two ways of doing this. The easy way is to build a toolbar manually, and then close it. Once closed, the toolbar still exists, it's just hidden. You then have a macro in your ThisWorkbook module that sets its .,Visible property to true on opening and flase on closing.

Please Login or Register  to view this content.

The tricky way would be to build the toolbar "on the fly" every time the workbook is opened and delete it as the workbook is closed. This way is usually preferred because the toolbar would never be available to another workbook and would always be available to the workbook requiring it - whichever computer it would be opened on. Which one you go for depends on how comfortable you are with VBA coding.

HTH

DominicB

[erikhs]

Good afternoon erikhs
The tricky way would be to build the toolbar "on the fly" every time the workbook is opened and delete it as the workbook is closed. This way is usually preferred because the toolbar would never be available to another workbook and would always be available to the workbook requiring it - whichever computer it would be opened on. Which one you go for depends on how comfortable you are with VBA coding.

HTH

DominicB

Good afternoon Dominic,

I would definitely prefer to build the toolbar in vba, although i already have customized it in excel. I am quite comfortable with vba, just not with toolbars and Open/Close subs
Perhaps you have a link to some VBA code for inspiration?

Thank you!

[dominicb]

Hi erikhs

Have a look at the code below, this will build a toolbar on opening and remove that toolbar on closing. If you are building your own toolbar you can only point to macros, not exisiting commands, but simple recorded macros are quite sufficient - that's the .OnAction command. Have a play and fire any questions back.

Please Login or Register  to view this content.

Don't forget to put this code in the ThisWorkbook module within the VBE.

HTH

DominicB

[erikhs]

Thanks Dominic!,

I will try it out now, i think it is just what i was looking for!

[erikhs]

Hi Dominic,

The code worked out great, however how do i create a custom button name, i.e. what faceid is it, and what property controls the displayed text of such a button?

[dominicb]

Hi erikhs

What image is displayed is determined by the . FaceID control. To see a toolbar listing .FaceID images (there are several thousand such images) and the relevant reference number, download and install this add-in by Jim Rech :

http://www.oaltd.co.uk/DLCount/DLCou...e=BtnFaces.zip

When installed it will add an extra item to the tools menu to show the toolbar.

HTH

DominicB

[erikhs]

Hi erikhs

What image is displayed is determined by the . FaceID control. To see a toolbar listing .FaceID images (there are several thousand such images) and the relevant reference number, download and install this add-in by Jim Rech :

http://www.oaltd.co.uk/DLCount/DLCou...e=BtnFaces.zip

When installed it will add an extra item to the tools menu to show the toolbar.

HTH

DominicB

Hi,

I think you misunderstood me, i would like to write the text that should be displayed ON the buttons. Example "MyButton 1", instead of in your example a "1". If i do it manually it's right click toolbar -> customize -> commands-> macro -> Custom Menu Item -> drag -> change name.

Not the best description i know

[dominicb]

Hi erikhs

Oh, OK. Try replacing the .FaceID with .Caption

Please Login or Register  to view this content.

HTH

DominicB

[erikhs]

Hi erikhs

Oh, OK. Try replacing the .FaceID with .Caption

Please Login or Register  to view this content.

HTH

DominicB

Back from some time off!

That's excactly what i was looking for, thank you!