I have a Workbook in which I want the Worksheets to be protected. Everything
is done with MACROS, and the MACROS both Unprotect and Protect the
Worksheets. I manually Protect the Worksheet and save it. Then I retrieve
it and run one of the MACROS. It asks for the PSW going in, but not coming
out. Then I save it and go thru the process again. This time too, the
Worksheet is Protected, but when I run a MACRO it doesn't ask for a PSW. Nor
does it ask for the PSW if I Unprotect it manually.