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
Excel shortcut (Ctrl + Alt + L) error
Hi @TommyAuYeung-3007,
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.
And by your screenshot it looks like it executes some customer VBA code, which we don't know in detail.When I pressed Ctrl + Alt + L to apply the filter function
Ask the developer of that code what could be wrong.
5 people are following this question.
