| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto protect or run VBA?
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!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grayed out Auto-Sum on Protect Worksheet | Excel Discussion (Misc queries) | |||
| Macro Button or Auto Protect Formula | Excel Worksheet Functions | |||
| how to set auto protect workbook on exit? | Excel Worksheet Functions | |||
| How do I auto-protect a worksheet? | Excel Worksheet Functions | |||
| Auto Protect workbook with password upon opening | Excel Worksheet Functions | |||
![Michel[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
