Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: Saving a file with a Macro
This question will seem silly, but I am going to ask in spite of that. I
have created a spreadsheet/file with a Macro in it. When I attempt to save it as an .xlsx file I am given a message that includes the following: The following features cannot be saved in macro-free workborks: *VB Project To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list. To continue saving as a macro-free workbook, click Yes. I'd like to know if I MUST choose "Excel Macro-Enabled Workbook" from the "Save As" list in order to save the file since it has a macro. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: Saving a file with a Macro
Hi Gary,
yes you can the extension of the file has to be xlsm so for example yourname.xlsm "Gary" wrote: This question will seem silly, but I am going to ask in spite of that. I have created a spreadsheet/file with a Macro in it. When I attempt to save it as an .xlsx file I am given a message that includes the following: The following features cannot be saved in macro-free workborks: *VB Project To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list. To continue saving as a macro-free workbook, click Yes. I'd like to know if I MUST choose "Excel Macro-Enabled Workbook" from the "Save As" list in order to save the file since it has a macro. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't open an excel file (have 2007, Vista) without saving first | Excel Discussion (Misc queries) | |||
Microsoft Excel 2007, Sharing Violation when saving file | Excel Discussion (Misc queries) | |||
Why does 2007 EXCEL shut down when saving file as .XLS | Excel Discussion (Misc queries) | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
saving to csv file from excel 2007 | New Users to Excel |