Using an input box to enter information into the header section of page setup

Hi,

I'd like to click a button when I go into a new workbook which prompts me
for the customer name and then puts it into the header section of Page
Setup, is this possible?

If so could someone post the relevant code or point me to a webpage with it,
I've done some checking but can't find it on the web.

Thanks in advance,

George

You would need to institute application level events:

for documentation and some explanation on Application Level Events, you
might want to read Chip Pearson's site
http://www.cpearson.com/excel/appevent.htm

There are several schools of thought on implementing these, but that isn't
critical to this discussion. You would use the application level event to
trigger a macro when a New workbook is opened. In the event you would show
an inputbox

ans = Inputbox("Enter the Customer Name:")

then you would do the pagesetup. (you can get the basic code for this by
recording a macro while you set up a header manually)

--
Regards,
Tom Ogilvy

"George Taylor" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'd like to click a button when I go into a new workbook which prompts me
> for the customer name and then puts it into the header section of Page
> Setup, is this possible?
>
> If so could someone post the relevant code or point me to a webpage with
it,
> I've done some checking but can't find it on the web.
>
> Thanks in advance,
>
> George
>
>