Home > VBAUsefulCodes
Protect the sheet with some passwords, so that we can restrict the content of the sheet for others modification. Ex: we can make the sheet readonly, so that others cant edit the sheet without password
Protect Sheet VBA
Protect the sheet with some passwords, so that we can restrict the content of the sheet for others modification. Ex: we can make the sheet readonly, so that others cant edit the sheet without password
Sub sbProtectSheet()
pswd = "VBA$123"
ActiveSheet.Protect pswd, True, True
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts