Hi,
I need to be able to force the user to save the spreadsheet by use of
VBA as opposed to useing the save button or using the File\ save in excel
2003 or Office button ect in excel 2007. This is so that i can keep the
original file as an empty form, and to ensure the file is saved in the
correct location.

many thanks
lee