suppress saving dialog

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
I have a sheet that I save and suppress dialogs with:

application.displayalerts=false

However once the workbook gets large and it takes longer to save the saving progress bar pops up after a few seconds. How do you hide this bad boy?

Jesse
 
Hi Jesse

What exactly are you trying to do? Are you trying to suppress the SaveAs dialog, or the progress bar? And by progress bar do you mean the status bar? Perhaps you mean to hide the status bar:

Code:
Public Sub Demo()
    Dim blnStatusVisible As Boolean
    
    With Application
        blnStatusVisible = .DisplayStatusBar
        .DisplayStatusBar = False
    End With
    
    'code goes here
    
    Application.DisplayStatusBar = blnStatusVisible
End Sub
 
Thanks Jon, I'll give that a shot.

Jesse
 
I have a sheet that I save and suppress dialogs with:

application.displayalerts=false

However once the workbook gets large and it takes longer to save the saving progress bar pops up after a few seconds. How do you hide this bad boy?

Jesse
Do you have any other event code in the thisworkbook module or a worksheet module?

Regards,
Simon
 
Nope, no event codes at all. The code isn't even in the sheet I'm operating on, it's in an add-in.

Jesse
 
Back
Top