How to get rid of message when saving in XLS format

Topic

New Reply

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,
and I am worried that one day I will accidentally click the wrong button. Is there an option somewhere to disable this message?

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

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).

Reply | Quote

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).

So much for consistency.

Thanks for your persistence.

Reply | Quote

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)

Reply | Quote