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

 

[johnnyL]

Correct. Editing the registry only affects the computer that you edited the registry on.

I must warn you!!! If you are not familiar with making registry edits, I would not advise it.

That being said, you could create a 'batch' file to run on several computers, one at a time to speed up the registry edit process for several computers. As I warned though, be sure you know what you are doing.

 

[Pinaceous]

Alright, interesting. I'll have to look into that one. Appreciate it.

 

[Jaafar Tribak]

I have never seen such dialog poping up when saving a workbook !

 

[Pinaceous]

Jaafar Tribak!

I know you know how to back code the excel in lieu of the Registry through the

Declare PtrSafe Function

Declare Function

or something like that!

Let us know man! Your coding skills I do know!

Thanks,
pinaceous

 

[Jaafar Tribak]

Jaafar Tribak!

I know you know how to back code the excel in lieu of the Registry through the

Declare PtrSafe Function

Declare Function

or something like that!

Let us know man! Your coding skills I do know!

Thanks,
pinaceous

Thing is I have never encountered that excel popup ... The dialog I know of is the one that pops up asking whether the user wants to save the last changes when trying to save un unsaved workbook .

 

[Pinaceous]

Hi Jaafar Tribak,

Oh, I see. I have it set to automatically save upon close/exit of the workbook and just wanted that produced excel popup to run in the background, if at all possible.

Do you think you can take a look into it?

Thanks!
pinaceous