MACRO TO SAVE & EXIT ALL WORKSHEET/WORKBOOKS

R

Ram

Pls guide me to solve this problem. I use ..
-------------------------------------------------
ub CLOSE_ALL(
Application.ScreenUpdating = Fals
Application.DisplayAlerts = Fals
For Each w In Workbook
w.Sav
Nex
Application.Qui
End Su
-----------------------------------------------------
When I click the macro it show message

Can't execute code in break mod

any idea? Pls guide me from star
 
E

Edgar

Hi

I am no expert in VBA but the prompt you are explaining is
when you try to run the code when it is in Break Mode i.e.
The code is running in a debug mode.

Go into the code window and hit the stop button and then
retry executing the code.

HTH
 
Top