auto protect or run VBA?

[Michel]

How can I be shure no-one can change any data before my login/pass
routine has been succesfully run. I mean the could disable the macro's
before starting the workbook or they can even press ctrl-break to stop
the running user/pass VBA!!!

 

[Harald Staff]

You can never be sure, Excel is not built for high security. The best thing you can do as
far as I know, is to make the workbook completely useless if your code isn't completely
finished. Usually that is done by unhiding or unlocking, and re-hiding/locking before the
file is closed. If code is disabled or interupted then you have a workbook with everything
locked/hidden.

 

[Michel]

Well, if I would hide and lock the sheets until the code is running
than they could save the workbook before the code can hide and lock it
again, not?
Or is there a way to auto start VBA before it get's saved?