Stop users password protecting a workbook

[TheAntisocial]

Hi all.

Is there a way to prevent users from password protecting a workbook?

A colleague of mine has several workbooks that he updates using a seperate workbook and VBA, however, depsite being told not to, some of the owners of the workbooks he updates keep password protecting them which prevents his code working.

Is there any code that he can use in these workbooks to prevent users from password protecting them?
Some sort of intercept that would pop up a 'stop it' message would be ideal.

Thanks for any help.

Dan.

 

[Michael M]

this may be what you're after...

Excel VBA: Macro Code To Run Macros On Protected Worksheets & Sheets

 

[Kyle123]

No, there isn't AFAIK

 

[TheAntisocial]

Hi guys, thanks for the responses.

Michael - that would be ideal but my colleague has no idea what the passwords are, or who will add them. SO sadly won't work in this instance.

Kyle - that's not what i wanted to hear but thanks for the reply, i guess he'll just have to think of something else!

Dan.

 

[AkaTrouble]

if your colleague is the originator of the files that are being password protected he could install an open event that disables the ability to password protect

not sure of the code but am sure i have seen it on forum here

the other way is to create a macro or on close event that creates a data only copy of the workbook on closing to either a network location or to csv file etc that could then be used as the data source

this would not need the password as file is already open, this macro could be set a a close button and the file save / save as disabled

if he has a requirement for the data files then the person providing them should be made aware of the copies and to send those instead of passworded version.


however these are only workarounds for the problem that should be solved by IT policy from the management that oversees both your colleague and the person pass-wording the files.