Worksheet Password Protection in VBA

G

Graham

Hi,

I have a workbook in which users are inputting data via
user forms. Each time data is entered, or the file changed
I am protecting the sheets, but without a password, using
the following script.

ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True

Is there script (or other method) that I can use to assign
a password so that the worksheets are protected with
password and cannot be amended by simply clicking
Tools>Unprotect Worksheet?


Help gratefully received
 
Top