How to stop save-as format warnings

  • Thread starter Thread starter Peter B. Steiger
  • Start date Start date
P

Peter B. Steiger

I don't use Excel to design the Sistine Chapel; I use it to keep simple
lists and tables, one page per file. I don't want to save it in the
newest whiz-bang document format every time my boss forces yet another
"upgrade" on me; I want to save it in a backwards-compatible format
readable by anyone I send the file to, whether they're on Excel '95,
OpenOffice, or whatever. So I always choose "Save As..." and change the
format back to Excel 5.0/95 Workbook.

OK, I can accept needing to verify that's what I really want the first
time I save the document. But from then on, when I just hit ctrl-S to
save, is there any way I can stop it from asking me every stinkin' time if
I know what I'm doing? I have hunted through the myriad Options menu
items (what's the difference between "Customize" and "Options"? Oh,
forget it...) and through the registry, and I can't find anything that
will shut up the stupid Guardian Of Preferred Save Formats.

Help!
 
I don't think you'll ever find a setting to turn off those settings.

Maybe you could use a macro that turns off the alerts, saves the file, and turns
the alerts back on.

In fact, in my simple testing, I didn't even have to play with the
alerts--saving via a macro didn't make the alerts appear (xl2003).

Option Explicit
Sub testme()
Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Dave/Peter

Wouldn't you have to specify file format the first time you saved?

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs , FileFormat:= _
xlExcel9795
Application.DisplayAlerts = True


Gord Dibben Excel MVP
 
Yep. I used .save and tried to avoid that first save situation.

(I figured that one irritating message would be ok <bg>.)
 
Back
Top