Excel - Saving a Macro-Enabled Workbook

preview_player
Показать описание
Grab the Free VBA Quick Reference Guide
Saving an Excel File as Maco Enabled with use the XLSM file extention istead of the default XLSX.

See Instructions below with link

Follow these steps to save a macro-enabled workbook:

1. Click the File tab and then choose Save As. The Save As dialog box appears.
2. Enter a name and select a location for your workbook.
3. Click the Save as Type drop-down arrow. A list of file types appears.
4. Select Excel Macro-Enabled Workbook. ...
5. Click Save.
Рекомендации по теме
Комментарии
Автор

i saved macro file in .xlsx extension...now i want to open that file again and want to back my macro code in VBA module which i created..so how can i get back VBA code ...please reply

mayamali