My work requires monotonous and somewhat time consuming input of headers and footers (h and f). I currently have a macro set up to automate these h and f with both static and non-static information (as seen in the code). What I wondering is if there is a way to allow user input for those items that need to change (e.g. company name, title of paper, reference (X-X-1), etc.) or if there is a better way to do this.
Please Login or Register to view this content.
First of all, you don't need all that information. All you need are the parts of the header and footers that you are actually changing.
I suggest you give the user a sheet where they can set this information up. In the attached I made some named static ranges containing the strings you want to print. I could have referenced page and range but L_Foot makes a lot more sense than Sheets("Header Footer")!Range("$B$3") and it also takes a lot less typing.
I've simplified some of the assignments. As I mentioned before, once you get the fonts set, they'll stay that way until changed manually or by code.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
That works, except what about bold fonts, margins, and sheet orientation? I use both horizontal and vertical orientation. Sorry for the late, late reply - I sometimes forget to check back.
Don't worry about the late reply. I just got back from vacation myself - it may be a day or two before I get back to this one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks