Unprotect Workbook in a Macro

[LauraEFord]

How do you turn off the the protection on workbook in a Macro? Using Outlook 2013

I have a macro that after I lput in my passwork and run the macro, it takes the protected file, removes links, removed data, and saves a stripped down version of the data. My issues is when the other users get the file, the password is still needed. Below is the code of I have come up with using excel and Mr. Excel msg board. Can someone tell me the proper syntex?

'unprotect sheet
ActiveWorkbook.Unprotect Password:="prodexecdoc"

Thank you

 

[JLGWhiz]

How do you turn off the the protection on workbook in a Macro? Using Outlook 2013

I have a macro that after I lput in my passwork and run the macro, it takes the protected file, removes links, removed data, and saves a stripped down version of the data. My issues is when the other users get the file, the password is still needed. Below is the code of I have come up with using excel and Mr. Excel msg board. Can someone tell me the proper syntex?

'unprotect sheet
ActiveWorkbook.Unprotect Password:="prodexecdoc"

Thank you

I would think that your choice is to furnish the password to other users, or send them an unprotected file.

 

[LauraEFord]

Yes, I would like to send them the file unprotected. The second option would be to send them a password protected file with a different password.

 

[LauraEFord]

Can somene tell me the macro code that would turn off the password protection on the newly saved file?


OR My second option I would have would be to give the new file a new password. What would line of code be?

 

[JLGWhiz]

Can somene tell me the macro code that would turn off the password protection on the newly saved file?


OR My second option I would have would be to give the new file a new password. What would line of code be?

This unprotects the workbook, not the sheet.

unprotect sheet
ActiveWorkbook.Unprotect Password:="prodexecdoc"

For the sheet

ActiveSheet.Unprotect Password:=(If there is a password for the sheet)

Then make sure the file is saved while unprotected.