Saving in Excel 2000

M

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
 
B

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)
 
M

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
 
E

EARTHWALKER

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