Forum home » Delegate support and help forum » Microsoft Excel Training and help » Saving Macro in .xls file extension
|
|
|
The UK's most regular 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. |
Saving Macro in .xls file extension
Resolved · Low Priority · Version 2003
Reply Wed 7 Sep 2011, 13:48Delegate Herman said...
Herman has attended:
Excel VBA Introduction (1 day) 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?
For upcoming training course dates see: Pricing & availability
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.
|