Good morning,
I have a predefined Pivot Table report where users use a userform to change the report filter. The textbox on the userform populates a hidden cell in the workbook which then triggers a worksheet change event to update the report filter cell. If the user enters a wrong value, I get a "No item of this name exists in the pivot table report" message which allows you to hit OK to rename the report filter. Can I write code to intercept this message with my own message box that allows the user to hit OK and start again?
Thank you in advance
Bookmarks