98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Saving Macro in .xls file extension
Saving Macro in .xls file extension
Resolved · Low Priority · Version 2003
Wed 7 Sep 2011, 13:48Delegate Herman said...
Herman has attended:
Excel VBA Introduction course
Saving Macro in .xls file extension
When I save the Excel in .xls, the macro I wrote is gone. Thus, I have to save it as .xlsm.
Can I know how to save the macro in .xls without saving it as .xlsm?
Thu 8 Sep 2011, 21:11Trainer Anthony said...
RE: Saving Macro in .xls file extension
Hi Herman, thanks for your query. The .xlsm file format was introduced by Microsoft in Excel 2007 to prevent macros accompanying standard .xls files and causing security risks. However, if you Save As the file in the 97-2003 file format you should find the macro remains intact.
If you need to access the macro but still keep Excel 2007 features intact, save it into the .xlsb file format.
Hope this helps,
Anthony
Thu 15 Sep 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Workbooks quicklyWhen you have several workbooks open in Excel and want to just close them all at once: |
