Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
page setup, header/footer | Excel Discussion (Misc queries) | |||
How do I set a date formula in the page setup header to add 10 | Excel Discussion (Misc queries) | |||
How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
how do you delete a header in Page Setup? | Excel Discussion (Misc queries) | |||
Copying page setup information | Excel Programming |