Simon,

1. If you manually create a toolbar and attach it to a workbook then,
you only need to make it visible when the workbook is opened
(plus maybe position it) and delete it when the workbook is closed.
2. If you are creating a toolbar each time the workbook is opened then
make sure you delete it (using on error resume next) just before you create it again.
Also, delete it when the workbook is closed.
3. Your code shows the OnAction assignment for the buttons but nothing
referring to the creation of the toolbar? Is it an attached toolbar or do you
create it each time?

Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Simon Lloyd" wrote in message
...

Hi Jim,

I have the Auto Open in a standard module that i have called mAuto and
yes the lines do have a dot before them so the offending line would
look like this if everything else was removed With
Application.CommandBars("matrix").Controls("Area Leaders").OnAction =
"ALbutt", i'm not back at work until tomorrow (i'm in the UK) so cant
work on the workbook until then, but it is strange how it works on the
PC you create the buttone on but then not on others unless they have
never opened the workbook!

Thanks,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=501430