Hi all,
I’ve created a macro that performs some calculations and updates a report sheet. I want to automatically protect the worksheet after the macro finishes running to prevent accidental edits as it is a shared document.


What’s the best way to do this in VBA? Also, how do I allow users to still select cells but not change anything?


Appreciate any help or code examples!