Save as Excel file with password VBA

[anilpatni1234]

I have a code which i use to save my excel file to a specified folder.

I want to modify this code so that i can add " password" to the file.

Basically it will save the file and the user needs to enter the password to open the file .

the code which i use to save as is :

Please Login or Register  to view this content.

[TMS]

See the Help for ActiveWorkbook.SaveAs (in the VBA, select the SaveAs command and press F1 to get the Help)

Syntax

expression.SaveAs(FileName, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodepage, TextVisualLayout, Local)

expression A variable that represents a Workbook object.

[anilpatni1234]

Hey,

Could you please guide me on where to put the code in the code which i have?
I am new to VBA. Please help me

[TMS]

You already have most of the code ...

Please Login or Register  to view this content.

[anilpatni1234]

hey thank you so much. this worked wonders for me.

[TMS]

You're welcome. Thanks for the rep.