Thread: Macros in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default 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