My file is opened (only 1 file is opened)
i need a vba code i will run the code and the file become paasword protected
Without putting the paasword the file cant be opened and without paasword it cant be modified
So plz have a look sir
My file is opened (only 1 file is opened)
i need a vba code i will run the code and the file become paasword protected
Without putting the paasword the file cant be opened and without paasword it cant be modified
So plz have a look sir
ActiveWorkbook.SaveAs ActiveWorkbook.Fullname, ActiveWorkbook.FileFormat, "yourpassword"
Change ActiveWorkbook to suit. If file is not saved already, add the fileformat type to replace ActiveWorkbook.FileFormat. Record a macro and save a file to a type if you don't know what the fileformat is for a file type.