macro conflict when saving

[already]

Hello

When opening my file I went to full screen (sub workbook_open) with a macro and when I close my file I went back to a normal screen also with a macro (BeforeClose)

code = Application.DisplayFullScreen = False or True

When closing the file even when I change nothing in my file the save dialog box appears and this gives me a serious conflict with following
macro (excel and windows crash)

Sub savebutton()
Application.DisplayAlerts = false
ThisWorkbook.Save
Application.DisplayAlerts = True
ThisWorkbook.Close Saved = True
End Sub

How can I work around this?

Thanks in advance for your help

Kind regards
Al

 

[jproffer]

Sub savebutton()
Application.DisplayAlerts = false
ThisWorkbook.Save 
Application.DisplayAlerts = True 
ThisWorkbook.Close Saved = True 
End Sub

Why save it twice. If you know it's saved then just close it.

Sub savebutton()
Application.DisplayAlerts = false
ThisWorkbook.Save 
Application.DisplayAlerts = True 
ThisWorkbook.Close
End Sub

 

[already]

Hi Jproffer

Thanks for your reply

I have disabled the "Application.DisplayFullScreen = False or True
" macro and have used your second macro but excel crashes again.
(but not windows). So it seems not to be a conflict between both macros.
Is it possible that this macro is not compatible with excel 2007?

Kind regards

Al

 

[already]

Hi

I have found out that the 'close' code causes excel to crash but only if
I use a button to run the macro. If I don't use a button and I run the macro via developer > macros > run it works fine.

Strange

Any idea?

Kind regards

Al

 

[jproffer]

If it's an alert causing your crash, then maybe:

Sub savebutton()
Application.DisplayAlerts = false
ThisWorkbook.Save 
ThisWorkbook.Close
Application.DisplayAlerts = True 
End Sub

Other than that, I'm at a loss but I'm sure there are many people here that will look at this and think "well there's your problem" and point it right out to both of us....I hope anyway.