Dave:

The toolbar shows up correctly, now. I also added an auto_close routine
that closes the toolbar and unloads the add-in when the template file closes.


Thank you very much for your help.
--
Barry Carroll

(Cleverly disguised as a responsible adult)
---------
PSC Scanning, Inc. assumes no responsibility whatsoever for any statements
made by me. I''m entirely on my own.


"Dave Peterson" wrote:

What's the name of the routine that builds the toolbar? Are you using
Auto_Open?

If yes, then you'll have to run that Auto_Open procedure in code. (I should
have mentioned it earlier--but I didn't think of it.)

The last portion of your code could look like:

If myWkbk Is Nothing Then
MsgBox "Opening the toolbar"
'open it
Set myWkbk = Workbooks.Open(Filename:=AddInFullName)
myWkbk.RunAutoMacros which:=xlAutoOpen
End If

====
As an aside: If the code that creates the toolbar were in the workbook_open
event, then you would have been ok.

<<snip
--

Dave Peterson