So I know in Excel VBA you can modify the active chart's layout easily enough using the applylayout (X) function, but my questions is this: Can you identify what the activechart's layout currently is?
for example:
I have a activeX control button on a page that I want to use to cycle through two formats using an if statement. So something like:
Now I know that doesn't work but does anyone know the equivalent?
Thanks in advance!
for example:
I have a activeX control button on a page that I want to use to cycle through two formats using an if statement. So something like:
Code:
if activechart.layout = 5 then
activechart.applylayout (3)
else
activechart.applylayout (5)
endif
Now I know that doesn't work but does anyone know the equivalent?
Thanks in advance!