Macros in Excel
Duke Carey wrote:
2007 allows you to save workbooks in (at least) 3 new formats:
.xlsx (no macros allowed)
.xlsm (macros allowed)
.xlsb (macros allowed, I think)
Open the file in 2007 and choose to save it either as an .xlsm or an .xlsb
"Beverly" wrote:
I have a large spreadsheet created in Excel 2003 that I want to bring over to
Excel 2007 that was created by someone else. I want to bring that file over
to Excel 2007 keeping all of the macros. How do I do that?
--
B
If you don't need the new features of Excel 2007, you can still save the
workbook with an .xls extension. That should keep your macros working.
Bill
|