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

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Papa Jonah" wrote in message ...
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