Monday 27 July 2015

How to save your recorded macro in Microsoft Excel 2007?

In previous version of Microsoft Excel with or without macro the file extension will be the same which is (Filename.xls) but when we use Microsoft Excel 2007 and onward the file extension will be different. Without Macro (Filename.xlsx) and with macro (Filename.xlsm), Therefore when you save file with macro you must select save as type “Excel Macro-Enable Workbook” instead of “Excel Workbook” otherwise your macro will be gone.

Thanks

No comments: