Help needed, Workbook needs repair on every open

[JumboCactuar]

Hi,
appreciate any help with this:

every time i open i get this:

The workbook and all macros work fine, but after saving and closing, when i reopen i get same error


I dont have a sheet4
any way to remove this error permanently?

thanks

 

[mole999]

Generally the next option is to open a blank book, and copy paste each sheet data to the new book, then your VBA, save that then run the new one

 

[JumboCactuar]

Generally the next option is to open a blank book, and copy paste each sheet data to the new book, then your VBA, save that then run the new one

Thanks for the reply, though i fixed it with this at the end of my macro

Sheets("Sheet4").Sort.SortFields.Clear