Whoa.. No Sir, unfortunately this wasn't the "fix." The first thing I notice is that code isn't running all the way through. When I enter a number and select OK, it creates a new sheet named "Blank_Form (II)" and doesn't make the original "Blank_Form" very hidden again. The "Blank_Form" is my template for creating the new sheets. I don't want users being able to access it and change it, so I made it very hidden until the new worksheet is being created. When a new sheet is being created, it makes it visible just long enough to copy it and then puts it back out of reach. As far as the naming goes, it's not using the Input Box to name the sheet. When I select Cancel, it also creates a "Blank_Form (II)." Either way, it stays on the "Home" sheet.


Again, I really wish I could attach the workbook. I know it would make it easier for you to diagnose. Let me know what other information I haven't provided or made clear and I'll do my best to clarify. Thanks again for all the help.