Saving in Excel 2000

[Macaco]

Hello Guys:

Does anybody knows if there is a way to save automatically when yo
exit an excel worksheet without having to acknowledge the Save dialog?

THANK

 

[Bob Phillips]

Add this code to ThisWorkbook code module

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Macaco]

Could somebody PLEASE guide me on how to do what Bob Phillips said t
do. I don't quite understand what he said. I know some on Excel but no
that much .

THANK

 

[EARTHWALKER]

Goto tools, macro, Visula Basic. Find ThisWorkbook and click on it.
Then enter the code Bob gave you and save