Save As File Types

New Contributor

I am using Excel 2016. Whenever I want to "Save As" a workbook, I am confronted with about 30 types in the dialog drop down. Is there any way to edit this list or somehow reduce the number of options? Many of the file types I never use and my most used types are usually buried down in the list where I have to search for them.

2 Replies

@arnettwhitsoninccom 

You cannot customize the built-in Save As dialog, but you might create a macro that displays a customized one. Check out the Application.GetSaveAsFilename method (Excel) 

Thanks, I'll look into that.