Automatically Protect Workbook with Password
Dinesh Kumar Takyar
0:00 / 0:00
Automatically Protect Workbook with Password
8 791 просмотр · 7 л. назад
Dinesh Kumar Takyar
112 тыс. подписчиков
8 791 просмотр · 7 л. назад
How to protect a workbook with encrypted password automatically using VBA. Here's the complete VBA code:
Sub protectmyworkbook()
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="C:\exceltrainingvideos\protectworkbookusingvba.xlsm", FileFormat:=52, Password:="TPio&2019", writerespassword:="TPio&2020"
Application.DisplayAlerts = True
End Sub
Private Sub Workbook_Open()
protectmyworkbook
End Sub