Is it possible to create a macro that deletes the workbook it's saved in ?
C Chip Pearson Jul 26, 2004 #2 Tessa, Try the following code: With ThisWorkbook .Saved = True .ChangeFileAccess xlReadOnly Kill .FullName .Close savechanges:=False End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Tessa, Try the following code: With ThisWorkbook .Saved = True .ChangeFileAccess xlReadOnly Kill .FullName .Close savechanges:=False End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
