I've done some searching and I'm lost. What I would like to do is unlock and lock the Project. Problem I'm having is when I lock the project I can't run other macros. I open the sheet and press a button and get the error that the project is locked. How can I Unlock the project and then lock it after the other modules run?
I've locked the workbook and when the button is pressed to run the macro's, I unlock the workbook protection and then lock the workbook when finished. Can this be done in the same way for the VBAProject?
Bookmarks