Hi. I have a workbook with a macro that fills the active cells. When I locked all the formulae to prevent them from inadvertent edits, the "Run time error 1004" appears everytime I go to unlocked cells.
My knowledge of vba and macro is to google, copy, paste, and record so I am at a loss on how to remove the error.
Thank you for the usual quick help.

Attached Files

SK Finance Report Training workshop Templates.xlsm (150.6 KB, 4 views)