Hi all
I'm trying to add a button to a chart, initially I recorded the process of inserting a button on the top right of my chart. When I play it back the button is almost invisible and to the top left of my chart. Any ideas about ensuring the size and location of chart remain constant.
thanks
Matt
ActiveSheet.Buttons.Add(5888160.75, 189666.75, 422678.25, 182290.5).Select
Selection.OnAction = "BrandBreakdownChart_Button1_Click"
I'm trying to add a button to a chart, initially I recorded the process of inserting a button on the top right of my chart. When I play it back the button is almost invisible and to the top left of my chart. Any ideas about ensuring the size and location of chart remain constant.
thanks
Matt
ActiveSheet.Buttons.Add(5888160.75, 189666.75, 422678.25, 182290.5).Select
Selection.OnAction = "BrandBreakdownChart_Button1_Click"