I do the accounts for a charity using their own forms. There is an Accounts Sheet where all entries are made and given a Transaction Code (TC). From there the data is picked up on other forms by using Lookup and Sum formulas. I also have a macro that runs an AutoFilter to extract certain TC codes and Copy to Another Location. This data is then copied to another worksheet. This has worked fine for years but I am now training someone else to do the acounts, so I have locked all cells containing formula and protected the worksheets so that he cannot corrupt anything.
Now the problem: when the macro is run it works fine, but always throws up an error message if the worksheet is protected. Runtime error '1004': "The cell or chart you are trying to change is protected and therefore read-only."
I have tried to run the macro using a keyboard shortcut, adding a button to the toolbar, and adding a button to the worksheet - all with the same result.