macro

[guest]

i want to make a macro record saving a file but it has to
be differnet name file on the sheet. example if i change
the name on the cell the save got to be the same name too
when i click on save the macro would be asign to a picture.

 

[Don Guillett]

try

activeworkbook.SaveAs Filename:=range("a1")