I suggest launching the macro using a shortcut to launch your macro. This article would be a good starting point.įurthermore, to avoid any issues, don't run a macro that has the SendKeys method using the Run button in the VBE since the keystroke must be sent to the Excel window and not the VBE window. I would recommend reading some articles to get yourself familiar with it before using it. ![]() And if you haven't guessed it, I'm talking about using the SendKeys method.ĭisclaimer: As always, using SendKeys is somewhat tricky and can lead to unexpected results. So, the reason why I'm explaining all this instead of writing a solution is because there is a workaround, but this kind of thing should only be used as a last resort. I even tried to see if we could save a funnel chart as a template and then use VBA to apply this template, but "Save as Template" is not available for some reason. I've tried all the standard VBA ways I could think of and this doesn't seem to work. ![]() I guess it has to do with the fact that the XlCategory axis becomes vertical when you are using the "Funnel" chart type:
0 Comments
Leave a Reply. |