Maybe I spoke a bit too soon!
Actually the issue isn't really with the code you provided...it does work brilliantly. But when I sent the file to the end user I encountered a security issue.
The project is password protected so that no one else can mess around with the code. In my testing, I always had the project unlocked as I was editing away in the VBE. But for the end user, when you reach the part of the code that adds the event handler to the newly created sheet, you get an error: Run-time error '50289': Can't perform operation since the project is protected.
From what I've read, it's not possible to unprotect/protect a project through code...even if it was I assume that would involve putting the plain text password in your code, and if anything ever went wrong and the program crashed it may be accessible. But that seems to leave me with not being able to protect the project....
Any ideas? I know we're going a bit astray from the original question here.