Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro?
Excel2003 ... I know nothing of writing Macros ... I only "record" them &
edit ... The following Macro is in a Pivot Chart WorkSheet of my WorkBook ... Issue is ... this Macro randomly activates an annoying "debug" pop-up. When this happens I simply select END in the pop-up & all is fine ... & ... Macro works fine. However, I would like to stop the random "debug" pop-up ... Can I do this? If so ... What would the "edit" be? ... Thanks ... Kha AND my Chart Macro is: Private Sub Chart_Calculate() ' A_Set_Chart_Format Macro ' ActiveChart.SeriesCollection(1).Select With Selection.Interior .ColorIndex = 29 ' .Pattern = xlSolid End With ActiveChart.SeriesCollection(1).ApplyDataLabels AutoText:=True, ShowValue:=True, _ ShowPercentage:=False, ShowBubbleSize:=False ActiveChart.SeriesCollection(1).DataLabels.Select ' Selection.AutoScaleFont = True With Selection.Font .Name = "Arial" .FontStyle = "Regular" ' .ColorIndex = 5 .Size = 8 End With ' Selection.Font.Bold = True ' Selection.Font.ColorIndex = 5 ActiveChart.Deselect End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro?
If you click on Edit, then you should be taken to the offending line of your
code. It may help you debug what's wrong with the procedure. Ken wrote: Excel2003 ... I know nothing of writing Macros ... I only "record" them & edit ... The following Macro is in a Pivot Chart WorkSheet of my WorkBook ... Issue is ... this Macro randomly activates an annoying "debug" pop-up. When this happens I simply select END in the pop-up & all is fine ... & ... Macro works fine. However, I would like to stop the random "debug" pop-up ... Can I do this? If so ... What would the "edit" be? ... Thanks ... Kha AND my Chart Macro is: Private Sub Chart_Calculate() ' A_Set_Chart_Format Macro ' ActiveChart.SeriesCollection(1).Select With Selection.Interior .ColorIndex = 29 ' .Pattern = xlSolid End With ActiveChart.SeriesCollection(1).ApplyDataLabels AutoText:=True, ShowValue:=True, _ ShowPercentage:=False, ShowBubbleSize:=False ActiveChart.SeriesCollection(1).DataLabels.Select ' Selection.AutoScaleFont = True With Selection.Font .Name = "Arial" .FontStyle = "Regular" ' .ColorIndex = 5 .Size = 8 End With ' Selection.Font.Bold = True ' Selection.Font.ColorIndex = 5 ActiveChart.Deselect End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |