Posted to microsoft.public.excel.programming

K[_2_]

external usenet poster

Posts: 557

MAKE SUBTOTAL APPLICATION ON AND OFF IN MACRO

Hi I want to get subtotals in the range (B1:K200) by every value
change in col B. Is there way that I can have some sort of macro on a
Toggle Button that when I press button then it should put subtotals in
the range but when I press it again then it should remove the
subtotals.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I make AutoSum really Sum, not Subtotal	Pearl	Excel Worksheet Functions	7	April 3rd 23 06:43 PM
sort macro, subtotal and add lines after subtotal	David	Excel Discussion (Misc queries)	1	August 29th 09 10:56 AM
Execute a Macro from one excel Application to another Application	Jason Zischke	Excel Programming	2	January 30th 08 11:45 AM
macro excel subtotal in subtotal	GBO	Excel Discussion (Misc queries)	2	November 29th 07 02:15 PM
macro to close excel application other than application.quit	mary	Excel Programming	1	September 14th 04 03:43 PM

All times are GMT +1. The time now is 05:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us