Originally Posted by
lynnnow
Andy,
The passwords that will be created will have to be known by you and the end user. For a read-only file, you can set a master password. Also, for the end user to insert a password, he'll have to tell you the password so that you can open the file, if that is the intention. If you do not have the password to open the file, then you will not be able to collate the data available in that worksheet.
For the file name and location, you can set these two values in a separate sheet of the workbook and make the code refer these two cells to put the created file on the network drive.
We would be able to help you much more if you were able to post an example of your ideas.
Best regards,