Pls let me know how to create macro that save all worksheet/workbook and exit TQ
R Ram May 3, 2004 #1 Pls let me know how to create macro that save all worksheet/workbook and exit TQ
D Don Guillett May 3, 2004 #2 Here is one I use ub CLOSE_ALL() Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Workbooks w.Save Next Application.Quit End Sub
Here is one I use ub CLOSE_ALL() Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Workbooks w.Save Next Application.Quit End Sub
R Ram May 11, 2004 #3 When I click the macro it show message Can't execute code in break mod any idea? Pls guide me from star
When I click the macro it show message Can't execute code in break mod any idea? Pls guide me from star
