Event For Protection

  • Would it be possible to write an event whereby if a sheet became unprotected for (00:00:01), that it would be automatically protected? This would severly limit a sheet haxrs ability to do anything, even if unprotecting a sheet, yet would allow code to be run which required sheet unprotection.

  • Re: Event For Protection


    Thanks Norie. I didn't expect so, but was wondering if any gurus had a trick up their sleeve.

  • Re: Event For Protection


    Hey Max,


    This sort of question crops up all of the time (not specifically the protection one mind you) and they can all be grouped under the general heading of


    "How can I make Excel Secure"?


    Truth is you can't... sure you can tweak a few things, but Excel isn't secure - period. :)


    Excel has some basic security, but was never designed as a secure/bulletproof environment - and there are no future plans to make it that way... Actually the fact that it is so "open" is probably why it became so popular in the first place.


    Basically, any half decent programmer can get around Excel protection PDQ, and Worksheet protection is one of the simplest to crack.


    As a general rule, I normally say that if you need to start hacking around with the security features of Excel in an effort to make them more secure, you're already using the wrong program.


    One thing you can do is to make sheets you really don't want people to see VeryHidden and password protect the VB module (which is probably the most secure area of Excel)

  • Re: Event For Protection


    Quote from Will Riley


    One thing you can do is to make sheets you really don't want people to see VeryHidden and password protect the VB module


    Done and done. I was just wondering if there was any way to implement sheet protection if it was haxrd. I could add protect code for worksheet_change, worksheet_activate, which would not make it perfect, just a pain in the a** for anyone who should try to mess with sheets.


    I know there's a way to get into everything. I have tryed hack one of my own workbooks to find out how secure it is. So far I have been unable to access the VBA project, using downloaded VB hack software, but I'm sure there are those that could. If I can't do it, however, I'm not too worried about my users.


    ***Disclaimer: I only use hack software on my own work to ensure security. I would not think about using it to hack anyone else's work. That would be unethical and immoral.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!