shyamvinjamuri
Board Regular
- Joined
- Aug 2, 2006
- Messages
- 175
Hi Guys,
Is there a way to protect and unprotect sheets and workbook through VBA?
Here is what I am looking for:
I want to unprotect the workbook and unprotect Sheet1, Sheet4 and Sheet 6, if the user ID is ABC. And, Protect all sheets and workbook on close.
Thanks
Is there a way to protect and unprotect sheets and workbook through VBA?
Here is what I am looking for:
I want to unprotect the workbook and unprotect Sheet1, Sheet4 and Sheet 6, if the user ID is ABC. And, Protect all sheets and workbook on close.
Thanks