VBA minimize excel popups

[Pinaceous]

Good Afternoon,

How would I minimize an excel generated pop-up?

For example, upon close of my workbook I have excel

 ActiveWorkbook.Save

.

This works good but now how do I minimize the excel generated pop-up from this code?

I was thinking something like

 ActiveWindow.WindowState = xlMinimized

but this does not minimize its pop-up only the workbook.

I've also tried

 Application.ScreenUpdating = False

but this does not work for the excel generated pop-up.

Any suggestions??

Thank you!
pinaceous

 

[johnny51981]

You might be looking for this lil nugget

    Application.DisplayAlerts = False

 

[johnny51981]

This is what I have for when my file is complete with its refresh:

Sub ExitExcel()
    
    ThisWorkbook.Save
    Application.DisplayAlerts = False
    Application.Quit

    
End Sub

 

[johnnyL]

Can I assume the pop up that you are referring to is a pop up asking to overwrite the file?

 

[Pinaceous]

Can I assume the pop up that you are referring to is a pop up asking to overwrite the file?

Hi johnnyL,

Yes. Using

ThisWorkbook.Save

as the example, the excel overwrite file message box still pops up even with the use of the above.

For example, the message box appears to be Saving and does not perform this task hidden as I would like.

Do you have any suggestions?

Thanks!
pinaceous

 

[johnnyL]

To disable the window shown in your picture, I believe would require a registry edit.

 

[Pinaceous]

How do I do that?

 

[johnnyL]

Do you have experience with editing the registry?

 

[Pinaceous]

No. Please explain.

 

[Pinaceous]

No. Please explain.

Well if I go into the Registry Editor for a specific computer does that mean that whatever changes I make to the Excel Registry will only affect that computer and not the specific file, correct?

So, if others use that file on a different computer, they will have to change their registry?