Hi all,

I am wanting a user to be able to select where the file is saved and the
code I have used is:

Application.Dialogs(xlDialogSaveAs).Show

But does anyone know how I can attached a password to this file after the
user has selected where they want to save the file and what they want to call
it?

The saveas function allows this, but I think it needs to know what the file
is called and where it is to be saved.

Any help would be much appreciated.

Thanks

Ashman