I need a macro that will do the following for a shared workbook:

1. Create a worksheet called "HIST"
2. Perform a track changes on: "When": All, "Who": Everyone, "List changes on a new sheet" checked
3. Copy and Paste everything from the sheet created in Step 2 to the sheet created in step 1
4. Hide the sheet from step 1
5. "Unprotect Shared Workbook" with password: [Password]
6. Apply a modification password on the workbook (A.K.A "Save As", "Tools" > "General Options" > "Password to modify:" [Password])

I anticipate an issue on step 6 since this is done in Windows Explorer, but a macro to do as much of this as possible will suffice.

Thank you!