| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SubTotals
I have a Macro that takes current subtotal in a range and removes them.
However, the Macro Stop and gives me a Message Box telling me that "Entire SubTotal will be deleted" Choice of OK or Cancel. How can I have it not ask me this and just automatically run remove the SubTotal? The line simple reads as follows: Selection.RemoveSubtotal Range("F8:AA321").Select -- MJM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SubTotals
try
Application.DisplayAlerts = False Selection.RemoveSubtotal Range("F8:AA321").Select U¿ytkownik "MikeM" napisa³ w wiadomo¶ci ... I have a Macro that takes current subtotal in a range and removes them. However, the Macro Stop and gives me a Message Box telling me that "Entire SubTotal will be deleted" Choice of OK or Cancel. How can I have it not ask me this and just automatically run remove the SubTotal? The line simple reads as follows: Selection.RemoveSubtotal Range("F8:AA321").Select -- MJM |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SubTotals
Excellent, Thanks!
-- MJM "Jarek Kujawa" wrote: try Application.DisplayAlerts = False Selection.RemoveSubtotal Range("F8:AA321").Select U¿ytkownik "MikeM" napisa³ w wiadomo¶ci ... I have a Macro that takes current subtotal in a range and removes them. However, the Macro Stop and gives me a Message Box telling me that "Entire SubTotal will be deleted" Choice of OK or Cancel. How can I have it not ask me this and just automatically run remove the SubTotal? The line simple reads as follows: Selection.RemoveSubtotal Range("F8:AA321").Select -- MJM |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SubTotals
Just under the start of the Sub:
Application.DisplayAlerts = False Just before the end of the Sub Application.DisplayAlerts = True Regards, Ryan--- -- RyGuy "MikeM" wrote: I have a Macro that takes current subtotal in a range and removes them. However, the Macro Stop and gives me a Message Box telling me that "Entire SubTotal will be deleted" Choice of OK or Cancel. How can I have it not ask me this and just automatically run remove the SubTotal? The line simple reads as follows: Selection.RemoveSubtotal Range("F8:AA321").Select -- MJM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
| Subtotals function offset subtotals summary | Excel Programming | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
Linear Mode
