Template that has to be opened every time.

[cauge]

I want to create a template that before opening, it asks you for 2 or 3 pieces of unique information (in the form of a something like a popup message box) that will be put in specific cells and protected. Therefore, in order to start a new file the next time - you have to use a brand new template and fill in the unique information again. This is to stop people from overwriting the last template (now saved as a workbook) by using "save as".

I know this should be possible using a macro in the template but I am having problems finding the information I need on the internet.

My questions:

Is this an easy procedure? Or am I going to be wasting 3 days doing it?

Can anyone direct me to information on how to get started?
Or give me an example of a macro starting prior to opening a template.

Thanks
Wendy

[theDude]

Wendy,

Copy this code to your template (replace references in BOLD w/your own):

Please Login or Register  to view this content.

Hope this helps,
theDude