MACRO TO SAVE & EXIT ALL WORKSHEET/WORKBOOKS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top