How to identify pivot chart on an excel worksheet using VBA -
i'm creating excel dashboard in i've placed pivot chart , want govern visibility click of checkbox. i'm not able identify pivot chart object on worksheet , hence can't use code can other activex control label. e.g. can find label 'lblsales' in sheet object can't find 'pivotchartrc' name of pivot chart there anyway can that?
private sub checkboxrc_click() if (checkboxresponsecurve.value) sheet1.lblsales.visible = true else sheet1.lblsales.visible = false end if end sub
Comments
Post a Comment