MACRO TO SAVE & EXIT

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

Guest

hi

I try using the following macro to save all worksheet / workbook then exit. I create button from drawing shape later assign macro into it. But when I run the following message appear. Pls guide me from the start
_________________________________
Can't execute code in break mod
_________________________________

ub CLOSE_ALL(
Application.ScreenUpdating = Fals
Application.DisplayAlerts = Fals
For Each w In Workbook
w.Sav
Nex
Application.Qui
End Su
 
Can't execute code in break mode

Press Alt + F11 to go to VBE
In VBE: Click Run > Reset

Btw, not sure whethe there's a typo in the post
but there's an "S" missing in the word "Sub" in
Sub CLOSE_ALL()

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
Param said:
hi,

I try using the following macro to save all worksheet / workbook then
Click to expand...
exit. I create button from drawing shape later assign macro into it. But
when I run the following message appear. Pls guide me from the start.
 
Back
Top