Re: Button Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
nigelnospam@xxxxxxxxx



"JT" <JT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1352DC1C-EBAB-46B8-A8B3-88FF071DE9B3@xxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: List ordering optimation
    ... (setf last-year year) ... (when month-list (push (reverse month-list) ... You could move away from ad-hoc data structures to ...
    (comp.lang.lisp)
  • Re: Reversing a list - Back again!
    ... OK - Plan B. Again assuming each line is a paragraph, the following macro ... will reverse the list on a place by place basis. ... London Town ...
    (microsoft.public.word.newusers)
  • List ordering optimation
    ... (setf last-year year) ... (when month-list (push (reverse month-list) ...
    (comp.lang.lisp)
  • Re: Aperture - love it.
    ... >>> Tell me what aperture setting is optimal for a macro to maximize focus ... > maximum depth of field you stop the lens all the way down. ... This will approx triple your magnification. ... Go here and search for 'reverse' for a better explanation: ...
    (comp.sys.mac.advocacy)
  • Re: autonumbering
    ... Hmm, if you want to number text in a single sequence, you can use the macro ... Note that the macro keeps track of the sequence by storing the current value ... reverse the order starting from 1 at the bottom of the sheet and adding ... create a reverse numbering sequence. ...
    (microsoft.public.word.docmanagement)