Перейти к содержимому

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