Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all.
I'm interested in making a macro that will do my "page set up" configurations for me. While I already have made one through manual record, and I've modified parts of it, I'm left with 3 elements that I do not know the coding for, or if it's even possible. In my footer, there are 3 panes. The left pane I hard-wire the date that I actually work the file. In my center pane, I place the file name-- but not &[file]. Again, I "hard-wire" the name. While I can hear a few comments stating that it'd be just as easy to use &[file], we try to avoid that here, as we've had troubles with it in the past, and not enough of us would pay enough attention to catch it beforehand. What we have in the right pane works as is, so that's unimportant as we're satisfied. So, my question-- with the footer, can I do an "application.inputbox()" for the two panes-- left, and center? If so, how would I go about coding something like this? I just need to better understand that part, as mentioned, I've already got the rest of it done, and it works quite well. Thank you. Best. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Excel 2010 files as web page or single file web page | Excel Discussion (Misc queries) | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
save page ,clear page, reuse same page | Excel Programming | |||
excel fit to 1 page shows 1 page but not all data is on that page | Excel Programming |