ActiveWorkbook.Sheets("MANUAL TS").Protect
i use the above code to protect a worksheet, what extra code do i need to
use a password
thankyou john