First save to save as

  • Thread starter Thread starter Shadow24
  • Start date Start date
S

Shadow24

"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!! :)
 
Hi

Check the "Saved" property, like this:

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

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Saves for one event (sheet1.xls) 2
save and exit macro 8
Saving a Workbook cause's Error's 7
SAVE AS/ GET SAVE AS/ 1
Save ActiveWorkbook dilemma 3
Save All Worksheets as CSV 7
calling up Save / Save As from a userform 2
button for saving all workbooks 6

Back
Top