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

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

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" wrote in message
...
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