Unprotecting worksheet through VB macro
Posted by Marc on January 04, 2002 8:45 AM
Would anyone know how to create a VB macro that would take a protected worksheet and unprotect it? Meaning, when the user opens the workbook, a sheet would be protected until you clicked on a command button that would unprotect it. I can't seem to find the correct order for this to happen and Excel's minimal VB programming language does show that it supports unprotecting. Thanks for any help anyone can give!