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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO TO SAVE & EXIT 1
Autofilter & copy results to new worksheet 0
save and exit macro 8
auto insert copy of worksheet 2
Autofiltering & copying results to new worksheet - custom message box 0
Macro to save all worksheet and exit? 2
BeforeClose VBA Question?? 0
Buggy behavior when Worksheet.Copy uploads to web server 0

Top