G
Guest
I have added 6 buttons to my spreadsheet. The last 5 are copies of the the
first one, so all of the properties are the same. There are control toolbox
buttons.
One of the buttons kicks off a macro to subtotal the sheet. I would like to
push the same button to reverse the subtotal.
When I push the button it kicks off the macro and subtotals the sheet. When
I try to push the button again (to reverse the subtotal), it doesn't work. I
have to click in a cell some where on the sheet before I can push the button
again. Other wise I can just click and click and nothing happens.
When I reverse it, the same thing happens. I can't subtotal again until I
click in a cells some where on the sheet.
I haven't seen this happen before. Is this some code I need to use to
"re-activate" the button again? Any help would be appreciated. Thanks.....
first one, so all of the properties are the same. There are control toolbox
buttons.
One of the buttons kicks off a macro to subtotal the sheet. I would like to
push the same button to reverse the subtotal.
When I push the button it kicks off the macro and subtotals the sheet. When
I try to push the button again (to reverse the subtotal), it doesn't work. I
have to click in a cell some where on the sheet before I can push the button
again. Other wise I can just click and click and nothing happens.
When I reverse it, the same thing happens. I can't subtotal again until I
click in a cells some where on the sheet.
I haven't seen this happen before. Is this some code I need to use to
"re-activate" the button again? Any help would be appreciated. Thanks.....