KishorKK Member Nov 19, 2016 #1 Hi All, I want to protect like 5 sheets at a time for that how to write a program? for a single one sub protect() sheets("sheet1").protect password:= 123 remaining ones how?
Hi All, I want to protect like 5 sheets at a time for that how to write a program? for a single one sub protect() sheets("sheet1").protect password:= 123 remaining ones how?
Khalid NGO Excel Ninja Nov 20, 2016 #2 Hi Kishor, These links may help: http://www.mrexcel.com/forum/excel-questions/336097-protecting-multiple-sheets.html https://www.extendoffice.com/documents/excel/1153-excel-protect-multiple-sheets-at-once.html Regards,
Hi Kishor, These links may help: http://www.mrexcel.com/forum/excel-questions/336097-protecting-multiple-sheets.html https://www.extendoffice.com/documents/excel/1153-excel-protect-multiple-sheets-at-once.html Regards,
Monty Well-Known Member Nov 28, 2016 #3 Hello Kishore. May be this. Sub Protect_Sheets() Dim ws as worksheets For each ws in Activeworkbooks.sheets ws.Activate ws.protect password:=123 next ws End sub Hope this helps..Keep learning.
Hello Kishore. May be this. Sub Protect_Sheets() Dim ws as worksheets For each ws in Activeworkbooks.sheets ws.Activate ws.protect password:=123 next ws End sub Hope this helps..Keep learning.
