Protect and UnProtect Sheets using VBA - Excel VBA Example by Exceldestination

[@londontownfc3440]

Thank you. D you have another video where you show how to protect specific sheets not all sheets. Thank you.

[@alvi65tube]

thank you... i am going to write a routine asking each time to input a pass when you want protect or unprotect multiple sheets

[@ExcelDestination]

Sounds great!

[@abdelfattahshalabi1335]

Thank you very much, very helpful

[@jstan3076]

Thank you, I found you solve my problem. Can you do DEMO using Toggle buttons and if protect can just Protect on selected sheet and not all

[@ExcelDestination]

ok.....will try

[@joetan1771]

thanks, i find that unprotect cause screen flashes to unprotect all WS, protect all sheets are quick. i have 10 ws.

[@emmanuelembate7114]

Is it possible to have another tutorial in protecting only specific cells in a worksheet? Thank you

[@ExcelDestination]

sure, let me try.

[@emmanuelembate7114]

@@ExcelDestination thank you.

[@Philip-dy3ww]

Very convenient!😍 also good learning video

[@ExcelDestination]

Thank you 🤗

[@briandelaney6354]

Just what I neeeded!! Thank you!!!

[@ExcelDestination]

Glad I could help!

[@PerezerepL]

Thank you! Easy to understand.

[@sounkakada1645]

Excuse me please you show VBA code bottun 1 protect cells sheet2 and 1 bottun protect for 1 sheet
Thank you very much

[@mr.write1433]

if i click the non protected the password becomes useless

[@TSGuideMan]

Plz VBA code ur website sir