Results 1 to 6 of 6
  1. #1
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    I have an encrypted, password protected Excel file that must be saved as a .XLS file so that it can be opened by other people who don't have the conversion pack installed.

    Every time I save the spreadsheet it displays this dialog box, [attachment=85541:Excel.png]
    and I am worried that one day I will accidentally click the wrong button. Is there an option somewhere to disable this message?
    Attached Images Attached Images

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Not that I know of. I'd create a tiny macro that handles the save, something like (untested!!):

    Sub SaveNoPrompt()
    Application.DisplayAlerts=False
    Thisworkbook.Save
    Application.DisplayAlerts=True
    End Sub
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    I wanted to hide that dialog box to reduce risk (because it has a default button that will save my Workbook in the wrong format). Ignoring every possible alert from the save seems even more risky!

    Additional testing shows that if I click Yes it just displays the Save As dialog box, which I can cancel, so I guess it is more irritation than risk.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I just tested and the code just saves the file in the current format, effectively selecting the "No" button. Basically this is contradictory to what you'd expect of the displayalerts=false setting (Help says the default action is done).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    [quote name='pieterse' post='793503' date='16-Sep-2009 09:45']I just tested and the code just saves the file in the current format, effectively selecting the "No" button. Basically this is contradictory to what you'd expect of the displayalerts=false setting (Help says the default action is done).[/quote]

    <shrug> So much for consistency.

    Thanks for your persistence.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Help of Excel 2007 does mention what displayalerts does when you do a save-as and the file exists (it overwrites, which is NOT the default action either). I guess this is consistent with the above (and I think most desirable)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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