Trying to close without the message do you want to save

G

Guest

The save alert is still popping up. What do I do to just open the page
"Open" and save without the pop up?
Private Sub Workbook_Close()
Application.DisplayAlerts = False
Application.CommandBars("Standard").Visible = True
Application.CommandBars("Formatting").Visible = True
Application.CommandBars("Visual Basic").Visible = True
Application.CommandBars("Control ToolBox").Visible = True
Application.CommandBars("Forms").Visible = True
Application.CommandBars("Web").Visible = True
Sheets("Open").Select
Range("A75").Select
For Each w In Application.Workbooks
w.Save
Next w
ActiveWorkbook.Close
End Sub
 

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

auto enable macros 5
Stripping down excel 2
MAJOR PROBLEM! --- Menu Bars don't unhide? 9
Disable Macro Workaround Doesn't Work! 8
Run time error 1004 - unable to get the chartObjects property of the worksheet class 1
Excel is Ignoring ThisWorkbook.Save event after Thisworkbook.Close call 5
Turning Off Cut & Copy in a Workbook 1
Run-time error '5' when I add code to allow filtering on protected sheet. 4

Top