Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have many workbooks in Excel 2003 containing macros. When I tried to save them in Excek 2007 format yje macroa are removed. If there is any way to keep my macros in Excel 2007? Thanks -- Eli Kedar Israel |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You must save the workbook as a "macro enabled workbook".
*.xlsm format Also set your security to "disable all macros with notification" or "enable all macros"...................not recommended. Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 07:21:02 -0700, Eli Kedar wrote: Hi I have many workbooks in Excel 2003 containing macros. When I tried to save them in Excek 2007 format yje macroa are removed. If there is any way to keep my macros in Excel 2007? Thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank You
-- Eli Kedar Israel "Gord Dibben" wrote: You must save the workbook as a "macro enabled workbook". *.xlsm format Also set your security to "disable all macros with notification" or "enable all macros"...................not recommended. Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 07:21:02 -0700, Eli Kedar wrote: Hi I have many workbooks in Excel 2003 containing macros. When I tried to save them in Excek 2007 format yje macroa are removed. If there is any way to keep my macros in Excel 2007? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I import a database from excel 2003 to 2007? | New Users to Excel | |||
Excel Macros from 2003 to 2007 | Excel Discussion (Misc queries) | |||
Excel Macros - Any Major Differences Between 2003 and 2007 | Excel Worksheet Functions | |||
Excel Macros 2003 into 2007 | Excel Worksheet Functions | |||
I was using Excel 2007, now 2003 and my Macros won't work | Excel Worksheet Functions |