Hi All,

I am new to VBA so please forgive this rather simple question.

I have written a macro which calls a user form and I can fill in all of the
data and populate the worksheet as I requrie.

My problem is as follows. I have saved the worksheet as a template. I want
the macro to run the first time a new document is created based on the
template. How do I do that ?

TIA
Peter