Hello everyone
I need vba code that enables me to do the manual steps of tools > vbaproject properties > Protection tab > uncheck lock project for viewing. Is it possible?
Uncheck lock project for viewing in VBE
-
- PlatinumLounger
- Posts: 4967
- Joined: 31 Aug 2016, 09:02
-
- Administrator
- Posts: 79699
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- PlatinumLounger
- Posts: 4967
- Joined: 31 Aug 2016, 09:02
Re: Uncheck lock project for viewing in VBE
I am working on a file that I should protect with vbe password. And while I am trying a lot of codes and working on temp copy of the main project, after each update I need to get rid of the password quickly and some other tasks so as to work quicker on the temp file..
-
- Administrator
- Posts: 79699
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Uncheck lock project for viewing in VBE
You could leave the VBE unprotected while you work on it, and only protect it when you send the workbook to others...
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4967
- Joined: 31 Aug 2016, 09:02
Re: Uncheck lock project for viewing in VBE
I thought of that but most of the time I forgot to protect it before sending.. Never mind
-
- Administrator
- Posts: 79699
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- PlatinumLounger
- Posts: 4967
- Joined: 31 Aug 2016, 09:02
Re: Uncheck lock project for viewing in VBE
I have already seen this topic and I could unlock the vbe successfully, but after closing the file the vbe asks for the password again so I need a way to uncheck the option I referred in my first post.
-
- Administrator
- Posts: 79699
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Uncheck lock project for viewing in VBE
That way you can't forget to protect the VBE before sending the workbook to others...
Best wishes,
Hans
Hans