ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import macros from Excel 2003 to 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/227603-import-macros-excel-2003-2007-a.html)

Eli Kedar

Import macros from Excel 2003 to 2007
 
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

Gord Dibben

Import macros from Excel 2003 to 2007
 
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



Eli Kedar

Import macros from Excel 2003 to 2007
 
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





All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com