VBA Header

Just a curiosity, but is there a way to 'automate' the header within a spreadsheet. I have a spreadsheet used as a pricing document, which means that each time its used for a different project. Often because more than one person uses it, the previous projects title name is left in the header. I was wondering if there is a way for a popup form or msgbox type item to appear once the file is opened, prompting the user to type the project name into it (to be entered into the header) before they can proceed to use the spreadsheet.

Thats a very good point that I had overlooked arlu, but in the majority of case 98% once a quote has been done its not edited at least not after the first instance of the file being opened, so I dont think it would be a major problem. Barryleajo, your suggestion seems to populate the header, but to make this a variable string based on input, would I need to do hdrstr = Application.InputBox(prompt := "Project Reference", type := 8)

I think I need more practice with the basics! Thanks for the help, I would have been pondering over that for quite some time.