Excel Vba Protect Sheet - Microsoft has some suggestions on options to protect your excel 2003 worksheets. You can also set a password, protect or unprotect shapes, and allow or restrict various actions on the sheet. What you are doing should be working, so more information may be needed. Web learn how to use vba to lock or unlock sheets in excel workbooks. Expression.protect(password, structure, windows) expression required. See the syntax, arguments, and examples of worksheet.protect and worksheet.unprotect methods. Refer to the protect sheet with password worksheet in this workbook 'step 2: Web learn how to use the protect and unprotect methods with a sheet object in vba. From help files (protect method): See syntax, example and feedback options for office vba.
Protect the worksheet with the password protect sheet with password thisworkbook.worksheets. Here is a little more info. See the syntax, arguments, and examples of worksheet.protect and worksheet.unprotect methods. Web learn how to use the worksheet.protection property to protect a worksheet and check its options in vba. Refer to the protect sheet with password worksheet in this workbook 'step 2: You can also set a password, protect or unprotect shapes, and allow or restrict various actions on the sheet. Microsoft has some suggestions on options to protect your excel 2003 worksheets. Web learn how to use the protect and unprotect methods with a sheet object in vba. See syntax, example and feedback options for office vba. Expression.protect(password, structure, windows) expression required. Web learn how to use vba to lock or unlock sheets in excel workbooks. I agree with @richard morgan. What you are doing should be working, so more information may be needed. From help files (protect method):