saving a macro enabled 2003 Excel file?

User avatar
mishmish3000
PlatinumLounger
Posts: 3691
Joined: 15 Jul 2010, 14:10
Location: Milton, TN

saving a macro enabled 2003 Excel file?

Post by mishmish3000 »

Good morning!
I'm working on the code module Hans provided from John Walkenbach's Excel Develop Tip page, on how to ensure that data validation is not deleted. Thanks, Hans, for finding that!
I'm using Excel 2007. I have to save the file, though, as Excel 2003 for some of the nurses. How can I save it in 2003 as a macro-enabled Excel file? That may seem like a goofy question but I'm not sure how to do it from Excel 2007. I see an option to save it as a macro-enabled 2007 file, or as a plain ole Excel 2003 file.
Thanks
MishMish3000
:evilgrin:
Anne

User avatar
HansV
Administrator
Posts: 78523
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: saving a macro enabled 2003 Excel file?

Post by HansV »

Excel 97-2003 files (.xls) are always macro-enabled. The distinction between macro-enabled (.xlsm) and non macro-enabled (.xlsx) file types was introduced in Excel 2007.

So just save your workbook as an Excel 97-2003 workbook (*.xls).
Best wishes,
Hans

User avatar
mishmish3000
PlatinumLounger
Posts: 3691
Joined: 15 Jul 2010, 14:10
Location: Milton, TN

Re: saving a macro enabled 2003 Excel file?

Post by mishmish3000 »

:grin:
well, color me educated! LOL
I didn't know that... I was expecting some other option when saving. Gosh, thanks!
MishMish3000
Anne