Protecting sheets; macros VBA

[oggsta]

I am trying to automatically protect a worksheet with a password, when a file is either closed or saved. This will avoid people forgetting to protect the sheet after it has been modified.

Is it possible to write a VBA script to enable this to happen, if possible could you please advise on the code.

I.e. once the user save or closes the files.
the code or macro automatically kicks into gear to protect the workbook.

Any help much appreciated.


Regards

 

[xlbo]

Just use the BeforeSave event with

sheets("Sheetname&quot.protect password:="passwordgoeshere"

as the line of code Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde