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