Hi folks,

i created a macro enabled workbook for people to use at work but i would like to add some code to prevent anyone from saving the data in the work book as i just want to let them use the macro to sort the information and then force them to save under a differnt name. this prevents my work book from getting corrupted and will always be blank so folks can paste their data to it and use the macro to sort it as needed. I just want to force them to save under a different name.