View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_4_] Harald Staff[_4_] is offline
external usenet poster
 
Posts: 70
Default auto protect or run VBA?

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.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Michel" wrote in message
om...
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!!!