Results 1 to 6 of 6

Thread: suppress saving dialog

  1. #1

    suppress saving dialog



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Acolyte Jon von der Heyden's Avatar
    Join Date
    Mar 2011
    Location
    Stellenbosch,South Africa
    Posts
    24
    Articles
    0
    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

  3. #3
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Make your file smaller? AFAIK there is no way to get rid of that.
    Regards,
    Zack Barresse

  4. #4
    Thanks Jon, I'll give that a shot.

    Jesse

  5. #5
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    324
    Articles
    0
    Quote Originally Posted by Jesse View Post
    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

  6. #6
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •