On the Before_Save block check the existing file name if it is not your
standard file name then the user already save it and you skip your input
boxes.

Unless I'm missing something.

--
Rui

"Cmenkedi" wrote in message
...
I am using 2007 and have developed a spreadsheet template that we use for
various customers. I would like to have input boxes pop up the first time
that the file is saved asking for customer name. I would then like this
passed on to the file name, but we do not save all of the spreadsheets in
one
particular folder. Each customer has their folder with sometimes many
different subfolders in each.

My question is:
Can I generate a file name but still have the save-as dialog box pop up to
pick what location I want the file saved to?

Thanks