I have several sparklines in my sheet and want to have an option to 'hide' them. I'm already looping through all of these (updating ranges etc.), can't find a 'visible' property.
So the alternative is to make the plot range one point or other creative approaches then?
Sparklines Visible property
-
- BronzeLounger
- Posts: 1258
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
-
- Administrator
- Posts: 78642
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sparklines Visible property
You could set the color to white (or rather, to the background color of the cells), e.g.
Range("C1:C10").SparklineGroups(1).SeriesColor.Color = vbWhite
Range("C1:C10").SparklineGroups(1).SeriesColor.Color = vbWhite
Best wishes,
Hans
Hans