Forum Discussion
Save As File Types
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
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.
