Hi all,

I am working on creating a report template which can be applied to a number of different "sites". I would like to run a Macro on template start which prompts the user to enter the site name. the macro would look like this:

Private Sub Workbook_Open()
InputBox ("Enter site name")
End Sub

I would like to write this site name into a field which I can place throughout the body of the document (sort of like a cell or name reference in excel).



Can anyone help me with the additional code required and the creation of a custom field from this code?

Alternatively, if there's an easier way to do this I'd love to hear it.

Many thanks!