Macro Button Dissapears

  • Thread starter Thread starter Gaffnr
  • Start date Start date
G

Gaffnr

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
 
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.
 
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"
 
thanks patrick - you are genius!
--
Rob Gaffney


Patrick Molloy said:
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top