Try something like this! (put this in your auto_open module)
With Application
.CommandBars("name of your commandbar").Controls("name of you
button").OnAction = "name of your macro"
End With
Hope this helps
Simo
--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...nfo&userid=670
View this thread:
http://www.excelforum.com/showthread.php?threadid=27139