Custom warning box when attempting to alter a protected cell

[dmankey1]

I have workbook with multiple worksheets each having a pivot table and chart. I must have these sheets protected as several people use them to input data. I already have a macro for updating the pivot charts using a refresh button that unprotects the sheet, updates the chart then protects it. Now I would like to replace the standard message "The cell or chart you're trying to change is on a protected sheet....." with a custom message notifying who to contact for changes. Any help??

 

[frank_AL]

Here's an old post from Mrexcel that appears to answer your question:

https://www.mrexcel.com/forum/excel...rror-message-popup-window-protected-cell.html