Password protect workbook on closure

[NesYo]

Hi, found plenty material on how to auto protect with VBA all sheets in a workbook on closure of the latter, but no info on how to auto protect the workbook itself (structure and window). Any ideas?

[AliGW]

https://docs.microsoft.com/en-us/off...rkbook.protect

https://analysistabs.com/vba-code/workbook/m/protect/

https://exceloffthegrid.com/vba-code...ect-workbooks/

Just three that I found when I Googled "VBA protect workbook".

[NesYo]

Just three that I found when I Googled "VBA protect workbook".[/QUOTE]


This is very basic and I use it. My goal is to make the workbook protected om closing it, as I may forgot to do so before sending it to other people.

[nordicdust]

If it is to make sure that it protects, you will need the Workbook_BeforeClose Event.

If you have a Macro called "Protect" to protect your workbook, then this should do it!

Please Login or Register  to view this content.

[NesYo]

Thanks. Made the macro, placed your code in This workbook.. does wok. Dis you tried it?

[AliGW]

Does or does not work? Please clarify.

[Vraag en antwoord]

Something like this?

In the ThisWorkbook module

Please Login or Register  to view this content.

[NesYo]

At workbook closure I get the following message: Compile error! Procedure declaration does not match description of event or procedure having the same name.

[Vraag en antwoord]

Place an example of your file with the code as you applied it.

[NesYo]

Attached sample

[Vraag en antwoord]

Please Login or Register  to view this content.

[NesYo]

Thanks but this protects the worksheets (which I already figured out), but not the workbook (the subject of my post)

[AliGW]

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

[NesYo]

Just to mention that the issue is still unresolved (does not work)... if somebody is confused by my typo in a previous post