opening toolbar with file

[Guest]

I have created a code that creates a toolbar within a file. However, it only
opens when I run a particular macro.
I would like this toolbar routine to run automatically when the file is
opened.

My hope is that if I can get that to happen, I can email the file for people
to use and they will have the necessary tool bars available.

First, is my hope (assumption) correct?
Second, how do I get a macro to run when a file is opened?

TIA
Papa

 

[Ron de Bruin]

Hi Papa

Run the code in this events in the thisworkbook module

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub

See this site for more information about events
http://www.cpearson.com/excel/events.htm