Can't save macro code

Hi,

I have a working macro code Thomas at EE wrote for me in fiile name "Test_6".  But I can't save into file "Test_7".

Can you please help.

Thanks.

Kathryn
Test-6.xls
Test-7.xlsx
KathrynTAsked:
Who is Participating?
 
DaveCommented:
That is because the xlsx file is not macro enabled

Try saving as a xlsm file (macro enabled) file type instead

Cheers

Dave
0
 
Ardhendu SarangiSr. Project ManagerCommented:
Hi Kathyrn,
since Test-7 is a plain excel file, you are not able to save the macro in it. Try saving the file as a .xlsm extension and the macro would be saved in it.

See attached
0
 
Ardhendu SarangiSr. Project ManagerCommented:
File with macro
Test-7.xlsm
0
 
zorvek (Kevin Jones)ConsultantCommented:
You have to save the 2007/2010 workbook as a macro workbook.

See attached.

Kevin
Test-7.xlsm
0
 
KathrynTAuthor Commented:
Thanks you all for your quick response.

I have a meeting with India in 1/2 an hour with this.

You guys are awesome.

Kathryn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.