Hello All I have a workbook Called Template....
What i want to do is when the User Opens the Work book....It should Prompt to say..."you are working on the template workbook...please enter a new Name...
The user enters a NEW Name...And a workbook from the template workbook is created from the users input, and is saved where ever the Template workbook resides...
Then it should close the template and open the New workbook (if possible)
When that reader Opens the new work book it should ignore the macro because its not the Template...
I hope this makes sence.
Thank you
What i want to do is when the User Opens the Work book....It should Prompt to say..."you are working on the template workbook...please enter a new Name...
The user enters a NEW Name...And a workbook from the template workbook is created from the users input, and is saved where ever the Template workbook resides...
Then it should close the template and open the New workbook (if possible)
When that reader Opens the new work book it should ignore the macro because its not the Template...
I hope this makes sence.
Thank you
Last edited: