Good morning,

It's been a while since I've dabbled in VBA and I am in need of help.

I have created an Excel workbook with different sheet tabs. When the
user first opens the workbook, I would like to have a dialog box open
up and ask them the name of their employees (as soon as they enter 1
name and hit OK, the next box pops up). These names will then replace
the Sheet Tab names already created in the workbook.

For example, when I open up the workbook for the first time, it should
prompt me:

"What is the name of your employee?"
I would enter Sam and hit OK.
Then the Sheet Tab already created which is named "Rep1" should be
renamed to Sam.
This would continue until all employees have their own sheets (I have
Rep1 through Rep12 already set up in the workbook allowing up to 12
employees).

Once it's completed, and the workbook is saved, the dialog box would no
longer appear since all the employees are already entered by the
manager.

Thank you in advance for any help you can provide.