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.....
--
JT

Are you saying you have two macros -one to sub total the other to reverse
it, if yes post your code as I suspect that may be the problem.



--

Regards,
Nigel




"JT" wrote in message
...
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.....
--
JT