removing the save as option from Excel 2010 document with VB Macro

Hi Guys

Completely new to the whole VB Macro thing!

I have been asked to try and keep a particular excel spreadsheet to only be saved within a specific folder and thought a VB macro would be the best way to achiveve this.. My on VB script knowledge is zero any was hoping you guys could help?

The name can be change but the only destination you can save is the one specific folder?

Any idea or point me in the right direction?

Thanks in advance!