Frank Freese
asked on
Lost command buttons
Experts,
I had command buttons from R6:R83, Column [0]. I did a filter, removed the filter now I have only a command button on R[6]C[0]. I've not deleted any, yet I can not see the only one command button in cell R6:C0
1392-Mem-Expenses-03-11.xlsm
I had command buttons from R6:R83, Column [0]. I did a filter, removed the filter now I have only a command button on R[6]C[0]. I've not deleted any, yet I can not see the only one command button in cell R6:C0
1392-Mem-Expenses-03-11.xlsm
ASKER
is there a way to recover?
Yes but it is very painful. I can try to write a code which can align all the button in that sheet right below one another but then you will have to finally arrange them manually by dragging.
Sid
Sid
ASKER
if you don't mind - thanks (off to the dentist)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks - great works folks.
You need to right click on the button, before you autofilter and click on "Format Control". Under "Properties" tab, select "Do not move or size with cells" :)
Sid