This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 91%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Hi Microsoft,
When I pressed Ctrl + Alt + L to apply the filter function, the below error message popped up. And it brought me to the VBA when I clicked Debug.
Could you advise how I can resolve this?
Thank you,
Tommy
Hi @Tommy Au Yeung ,
Your problem is related to Office VBA, I changed the tag to office-vba-dev. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
According to the error code and documentation, it seems that the implied control is disabled or invisible. What is "PivotTableInsert"? Maybe Milan could assist too.
Hi Viorel-1,
I do not know what "PivotTableInsert" is too. Could I just delete the VBA or Marco? If yes, how?
You can put an apostrofe before the shown Application.CommandBars.ExecuteMso "PivotTableInsert". This will comment the line so that it will not be executed. Maybe it is not needed for your filters.
When I pressed Ctrl + Alt + L to apply the filter function
And by your screenshot it looks like it executes some customer VBA code, which we don't know in detail.
Ask the developer of that code what could be wrong.