Hi Tony

If you use Excel 97 then

Try to Change the takefocusonclick property to false of the button
This is a bug in Excel 97




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



"TonyL" wrote in message ...
I have created a macro & it runs fine when activated from the macros list. I
have applied the macro as an icon on the toolbar but the macro does not run
correctly from the icon. It only completes about half of the code. Why is
this? Thanks

Tony