I've noticed the same behaviour.
I have tried this on two different Access databases. One Access 2000 and the other, Access XP.
In Access 2000, I cannot see the procs in the query window. They exist because the code functions, but they are not visible.
In Access XP, they are visible.
Must be a setting somewhere... just haven't had the time to investigate further yet. If anyone knows, I'd appreciate it.