| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button Dissapears
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Button Dissapears
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Button Dissapears
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Button Dissapears
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting -dissapears | Excel Discussion (Misc queries) | |||
| Macor Button Dissapears | Excel Worksheet Functions | |||
| I type words in the cell and when I make it wordwrap it dissapears | Excel Discussion (Misc queries) | |||
| Data dissapears when reformatting a chart | Charts and Charting in Excel | |||
| Excel 2003 - Drawing a Simple Line - Dissapears | Excel Discussion (Misc queries) | |||
Linear Mode
