Import macros from Excel 2003 to 2007

E

Eli Kedar

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
 
G

Gord Dibben

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
 
E

Eli Kedar

Thank You
--
Eli Kedar
Israel


Gord Dibben said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macros in Excel 2007 1
Can Excel 2007 run ".xlm" macros? 2
Macros in Excel 2007 3
Macros in Excel (Office 2007) 3
enable macros in 2007 1
converting excel 2003 to 2007 file formats 18
Excel 2003 Workbooks with macros (.xls) converted to Excel 2007 6
2003 xla Add In Macro convert to 2007? 3

Top