For some reason i tried adding this step, i saved the file first into a regular excel workbook. Then save it again into macro enabled workbook. Don't know why but it work. In other word, the solution provided is correct. Others might need to add that step in case previous steps didnt fixed it.