I can't save excel after edited the code

Question

I can't save excel after edited the code

Anonymous

I am getting this message before saving my work on excel workbook.

Please explain why this happen and what shall I do please.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

3 answers

Answer 1

Rory Archibald 18,875 Volunteer Moderator

If you need to keep the code, you will have to save the workbook in a macro-enabled format (eg xlsm rather than xlsx). If you don't need the code, just press Yes.

Answer 2

Anonymous

Thank you Rory for your swift reply.

I chose yes because I want to keep the macro, but what does it mean (macro free) please?

I clicked save but the macro disappeared. I want to keep the macro please.

Answer 3

Rory Archibald 18,875 Volunteer Moderator

Clicking Yes removes the macro (that's what macro-free means). You needed to click no, and then use the File - SaveAs option to save the file as a macro enabled file.

Share via

I can't save excel after edited the code

3 answers