Protect Workbook

[Desdenova]

For my job I have built a macro that needs to be monkey-proof protected, so no one can add information or make any changes to the file, except for those with the password.

I have found some codes that protect the workbook from save, save as and ctrl+s mode to save over the original file. But the Inputbox isn't solid, by the Cancel button and the Esc key.

What I need, is a VBA-code I cannot find on the internet and really have no knowledge of writing myself. The code for: File, Save As, Tools, General Options, Password when Open, Read Only recommended. Can anyone please help me out?!

[BellyGas]

in the VBA window you'll see various items listed in the projects window, find the section called 'Microsoft Excel Objects' for your workbook and expand it, scroll to the bottom and you'll see an object called 'ThisWorkbook'.

Open it up and you'll see a blank white sheet, there'll be 2 drop down menus at the top. Select 'Workbook' in the left hand one and then in the right you'll have all kinds of options to view. Each item in the right hand drop down box is an event that you can put code it.

For example, you could put the command 'cancel = true' in the 'before_save' event and then no user will be able to save it. And yes, the problem with that is then you can't save it......so you'd need to put in something like

Please Login or Register  to view this content.

You can do the same for all kinds of events like double clicking, etc. To disable the ESC key put

Please Login or Register  to view this content.

in the workbook_open event. Remember to enable it again on workbook close though....

[Desdenova]

Thank you for the quick reaction! I will give it a try!

[BellyGas]

Graag gedaan

[Desdenova]

The code works!!

I used:

Please Login or Register  to view this content.