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
 

Jon von der Heyden

New member
Joined
Mar 25, 2011
Messages
24
Reaction score
0
Points
0
Location
Stellenbosch,South Africa
Website
www.exceldesignsolutions.com
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
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Thanks Jon, I'll give that a shot.

Jesse
 

Simon Lloyd

Administrator
Joined
Apr 2, 2011
Messages
401
Reaction score
0
Points
0
Location
Manchester, England
Excel Version(s)
Excel 2016
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
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
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
 
Top