Use ActiveWorkbook.SaveAs and look at the password arguments in help.

--
Regards,
Tom Ogilvy

"Steve C" wrote in message
...
I have written/recorded code which takes one spreadsheet (FileA) and saves
it
to another location under a different name (FileB). I want my code to
also
automatically give FileB a password of "test" so that when another user
tries
to open it, it will prompt them for the password.

Thank you in advance for your help!

Steve C