Edit macro formular

  • Thread starter Thread starter legepe
  • Start date Start date
L

legepe

I have the following macro formula -

End With
ActiveWorkbook.Close False
End Sub

Which is closing the workbook down
Can someone tell me how i need to change it so it saves in its own nam
automatically when it closes.

thanks

legep
 
You must log in or register to reply here.

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

Run Macro If Cell have "x" value 0
Button looses Macro setting when running Macro 1
save and exit macro 8
VB Syntax to close Excel workbook not saving changes 1
help with VBA program to import and add formatted files to one file 0
Macro for all Excel Workbooks to print to PDF 2
Problem with ActiveWorkbook.Close command 3
2003 created Workbook casuses error when macro runs in 2007 2

Back
Top