I am using the code attached to protect a excel worksheet via a macro. It works fine except that users cannot add/edit comments on the cells. I figured out that if I unprotect the worksheet and reprotect it and check the "Edit Objects" option I can add comments again. But then once the Macro runs again I can no longer add comments.
Is there a switch/option I can add to the macro code to allow comments to be inserted/edited.