Oscar Charlie (2001)

About a boy, Charlie Spinner, who discovers that his grandfather, Oscar Spinner, is actually a secret agent. He acts senile but it is just a cover so that nobody would notice. After Charlie confronts Oscar with this they work together on a dangerous assignment.