Care to post your macro. Maybe it didn't disappear but was hidden when you
deleted rows/columns??? If so, set properties to NOT move.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gaffnr" wrote in message
...
I have created a macro and assigned it to a button.
When i click the button, the macro run perfectly but the button
dissapears.

I want the button to remain so that i can run it multiple times if I want
to. The same macro should also remain permanently linked to the button as
well.
Thanks
Rob
--
Rob Gaffney