Are you placing it in the template or are you putting in a workbook based on
that template?

Make sure you open the .xlt file--not File|new.



"gavmer <" wrote:

Hi Dave,

Thanks for the assistance. Im having trouble implementing this. When i
place this code into my template and save it, it disappears when the
template is opened next. The template should prompt the user each time
the template is opened. The tempate is basically the tool to attach a
reference in the footer and is not relevant to the workbook as it never
should be altered.

Could you please assist??

Cheers!!!

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson