Quote Originally Posted by zoolander_10 View Post
Thank you for your help once again.

I have followed your instructions and input the code into "thisworkbook". I assume that is the correct place for the code?

However when I press Save or Save as it just saves as the name it already is?

am i doing something wrong. I have created specific folders in my Z drive and I did change the code to Z from C where you had put C Drive by simpley changing Z for C.

Thank you.
This is a regular macro, place it in a regular module, and run the macro when you want to save it.