Hi all,

Apologies if this is a fairly basic question. Just need some VBA code to call up the Save As window every time a form control button is clicked in my spreadsheet.

I've used the following code:

Application.GetSaveAsFilename

... which works fine to bring up the Save As window but it only gives me the option to save as "Any File" type. However I need the "Excel Macro Enabled Workbook" type.

Thanks in advance.