Macro Button Dissapears
so true!
;)
"Gaffnr" wrote in message
...
thanks patrick - you are genius!
--
Rob Gaffney
"Patrick Molloy" wrote:
I've seen this
what happens is that the height of the button goes to zero.
use GOTO (F5) , special then click Objects then OK and your button ought
to
be selected.
Change the button properties to "don't move or size with cells"
"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
|