Why automatically unprotect my workbook everytime when opened?

[troublesomeVB]

Hi all,

Whenever I open up an existing excel workbook, the whole workbook is
automatically unprotected, which should not happen since it was
protected with a PIN before the last saving and the macro behind does
not unprotect the whole workbook at all times either. So why is this
happening?

This only happens to 1 specific spreadsheet not affecting others.

Thanks in advance
Frank

 

[Otto Moehrbach]

Frank
The only thing I can think of is that your file has a Workbook_Open
macro in the ThisWorkbook module or an Auto_Open macro in a standard module
that unprotects the file upon opening. HTH Otto

 

[troublesomeVB]

Thanks Otto for your point. Yeah it does have a Workbook_Open macro at
the background. However I searched the entire project and did not find
any instance of 'ThisWorkbook.Unprotect...'. Still not sure how this
happens sometimes(yeah only sometimes, maybe after I play around with
the spreadsheet. But still a mystery since the code behind the whole
workbook never unprotects it as confirmed by the search). It is really
mysterious indeed to me. =S

Many thanks again for shedding light =)

 

[dbahooker]

you should have a real security model; with roles; etc
try a database for starters--- lol

Excel isn't adequate for data entry.

-Aaron

 

[greaseman]

Aaron sure gets around! Data entry?!?!?!?!?! Huh????

He must be fun at business meetings. Microsoft was very wise to fir
him

 

[troublesomeVB]

Well Excel certainly has its limitations, but as far as I know it can
be very useful too(not just for data entry) on the other hand, e.g.
data validation, events handling(I mean events of all sorts) , some of
which may not be available for other tools, although I am really fed up
with it and VBA now...

P.S. Aaron does sound not boring at all actually with his very bold
ideas....Did he really work for MS before? If so I wonder to which
extent he should be responsible for the crappy(well to be honest not
exactly all despite almost all can be categorised under this!) MS
products...LOL

 

[greaseman]

troublesomeVB,

That's a good one! Never thought about "...Did he really work for MS
before? If so I wonder to which extent he should be responsible for the
crappy(well to be honest not exactly all despite almost all can be
categorised under this!) MS products..." If you look at Aaron's
postings, you would think he's the greatest thing since sliced bread,
and that the whole world is down on him.

Have a good day.....

 

[Don Guillett]

and that the whole world is down on him.
As well they should be.