VBA to detect if project is protected
Posted on 2005-03-24
* sorry if this is in the wrong section but I can't find a VBA channel *
Using VBA in Excel,
I want a macro that detects whether or not the VBA project is protected.
The Macro should be contained in the workbook that contains the project to be protected (I think that makes sense but I have have a beer or two)
If it isn't protected then the macro should protect the project with a specified password.
I want to make sure (I'm very forgetfull!) that my project is protected even if I have a sudden unexpected short deadline and I forget to protect the code.