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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Marek Cvrk" wrote in message ...
Hello,
When I run macro using button event clicked, macro is not able to
execute some actions on range object like calling of delete method or
setting of numberformat property. It falls on runtime error 1004 "delete
method of range class failed". But, when I run macro different way (workbook
open event or directly from VB editor), no error occures. I seems like some
protection problem, but I think, all protection is turned off.
Tank You for any help.
Marek