Brian Horton has been appointed as the new manager of Third Division strugglers Macclesfield until the end of the season.