How to dynamically set password for entire excel workbook?

May_Prince · April 18, 2023, 2:49am

I want to dynamically set password for the entire workbook without using third party activities

fernando_zuluaga · April 18, 2023, 3:10am

We can do this with invoke VBA and excel applications scope like this

Here is the txt doc

Sub SetWorkbookPassword()
Dim strPassword As String
strPassword = "yourpassword"
ActiveWorkbook.Password = strPassword
End Sub

Regards!

May_Prince · April 18, 2023, 4:14am

it is working if only the excel is open. It should work without opening …Please help

fernando_zuluaga · April 18, 2023, 4:19am

Kindly uncheck the visible property

Regards

May_Prince · April 18, 2023, 4:23am

I have unchecked and tried it is showing this error

May_Prince · April 18, 2023, 4:25am

I have deleted the file and only tried it as new file still this issue is there

fernando_zuluaga · April 18, 2023, 4:26am

That is because you already assing the password, so you have to fill the password in order tor ead it correctly again

Regards

May_Prince · April 18, 2023, 4:30am

Even if i am trying to creating the new file still I get the same error