Theatre and film actor also gained fame for taking over headmaster role in six Harry Potter movies following the death of Richard Harris