Run Time Error Protecting Sheet and Code Refreshing Sheet Delay

Hello,

There is workbook protection by selecting the green or red shapes in upper left of sheets.

On the Monthly Report sheet there is code to update budget amounts by month, category, subcategory and amount. When the workbook is protected and running the update code it has run time error pointing out that the cell or chart is protected. I cannot find what cell it is referring to that is stopping the code from running. Can someone please find that so the code can run to update the amounts when the workbook is protected?

Also when that is solved can the code run without the delay of the sheet (Monthly Report) refreshing?

Thank you

When you get the error and the Debug option comes up, which line of code is highlighted?

I've run the code with the sheets protected and unprotected and I get no error messages.

BSB

Yes thank you that does the trick.

Glad I could help

BSB