You are heading down the more difficult path to try to change the code
executed by the button. You are far better off to determine if the file
already exists. Check out the Dir function. You want something like this

if len(dir(Path and File )) 0 then 'The file already exists
activeworkbook.save 'so just save
else
activeworkbook.saveas Path and File
end if

HTH

"Tim Richards" wrote:

I have a macro that saves the template as an xls. file based upon cell
contents. The location is also based upon another cell contents. The macro
works correctly....once. After that, the template utilizes the last
location|filename that the macro used as the current location and filename in
the macro button.
The macro looks like this:
sPath = Range("B8").Value
If Right(sPath, 1) < "\" Then sPath = sPath & "\"
ActiveWorkbook.SaveAs sPath & ActiveSheet.Range("B9").Value
I am attempting to reset the macro prior to it running by using the "assign
macro" and "macro name" on the toolbar(macro button). I think I need to use
"MsoCommandBarPopup." command to accomplish this, but I can't get it to
work!( or maybe find a way to keep this from happening!) I am new to visual
basic and learning fast..... maybe not fast enough!
Thanks for your help.
Tim