Button Problem
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 |
All times are GMT +1. The time now is 04:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com