Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have created two chart's for the purpose of exporting it to excel through macro & I don't wish to show it to the user. But when I hide these Chart's using Conditional = 0 Then the macro fails. So is there some way by which the chart's will not be visible to the user but will be accessible through macro.
Regards
Amar
Have not tried, but it should work to have the graphs visible in a tab, which is not visible
HTH
Peter
Hi Amar,
Set the conditions based on a variable and change the variable using the macro. That should take care of the problem.