How to remove the 'modify' password, save the file and close?

Hello,

When you click on Save As > Tools > General Options, there are two passwords..."Password to Open" and "Password to Modify".

Currently, I have a workbook (let's call it Test123.xlsm) that has the password on "Password to Modify".

My question is, using VBA, how do I remove the 'Password to Modify', save the workbook with the filename as is, including the extension and then close that workbook?

i.e. Test123.xlsm have password on "Password to Modify"...once the macro run, the workbook name will still be 'Test123.xlsm', except that this time, when I open the workbook, it won't ask me to choose between 'Read Only' or input the password to modify

Currently I have the VBA code, but every time it wants to save, a window always ask, which I quote:

"A file named 'Test123.xlsm' already exists in this location. Do you want to replace it?

Please Login or Register  to view this content.

Try putting Application.DisplayAlerts = False before you save it. Set it back to True afterwards.