Jerry wrote:
I would like to know if there is some where in the Excel
object model where I can password protect a file through
automation? I can't use the "save as" function.


I think you will have to use the Save As function to apply a password
to be used on opening the file. Has the file already been saved? If
so you can Save As the same name again, specifying the password

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup