First save to save as
 

"The first time you save a workbook, use the SaveAs method to specify a name
for the file."

I have my save and save as buttons working I just need to know how to make
it so that if I press the "Save" button before I do "Save As..." it will
automatically point to the "Save As..." code

Thanks for any help!! :)

First save to save as
 

Hi

Check the "Saved" property, like this:

If ThisWorkbook.Saved = False Then
'Use SaveAs
Else
'Use save
End If

Regards,
Per

"Shadow24" skrev i meddelelsen
...
"The first time you save a workbook, use the SaveAs method to specify a
name
for the file."

I have my save and save as buttons working I just need to know how to make
it so that if I press the "Save" button before I do "Save As..." it will
automatically point to the "Save As..." code

Thanks for any help!! :)

First save to save as
 

Ok thanks!! :)

"Per Jessen" wrote:

Hi

Check the "Saved" property, like this:

If ThisWorkbook.Saved = False Then
'Use SaveAs
Else
'Use save
End If

Regards,
Per

"Shadow24" skrev i meddelelsen
...
"The first time you save a workbook, use the SaveAs method to specify a
name
for the file."

I have my save and save as buttons working I just need to know how to make
it so that if I press the "Save" button before I do "Save As..." it will
automatically point to the "Save As..." code

Thanks for any help!! :)