Unreadable Contents

[Binh Tran]

Dear all,

I encountered below messages when i am working on the excel-enabled macro.

When i click on Yes, the below one popped up.

I checked Sheet 1, 4 and 6 but there is no macro records.

Can you please help me to understand what had caused this problem and how to fix it? It said the file is repaired but it keeps appearing whenever i open the file.

Appreciate your help since i am really stuck here.

 

[Fluff]

It looks as though you have a macro(s) that sorts the 1st, 4th & 6th sheet in the workbook using the worksheet.Sort method.
When using that method you should always clear any existing sort fields, other wise you will get this problem.

 

[Binh Tran]

Thank you very much for your help. Appreciate that.

 

[Fluff]

You're welcome & thanks for the feedback.