1. P

    Insert a image as footer on multiple sheets based on a reference from Sheet1?

    I have a workbook with scripts/modules. And running through many of them with the logic of: For Each sh In Worksheets If sh.Name <> ..... etc ActiveSheet.PageSetup.CenterFooter = "& "&N" or whatever i need on each sheet. I am excluding Sheet1 from the 'loop'. But on Sheet1 i have a image...
  2. M

    Modify page and pages number in footer to print

    Hello everyone! I make a report (which does not depend on me, and I cannot have it done any other way) that is made up of two Excel files. In the second file I need the number of sheets to consider those that are already in the first. That is, if the first file has 2 sheets, the second file...
  3. J

    WORD: Macro to Cycle Through Headers & Remove Merge Fields / Change Formatting to Black

    Hi, Can anyone help with a macro to Cycle Through Headers & Remove Merge Fields / Change Formatting to Black? Thanks.
  4. P

    Insert data (from another worksheet) just before FOOTER (last row of the page)

    Hello, I would like a code that it will insert data (from another worksheet) that the data are 12 rows, just before FOOTER (last row of the page) and only at the last page. Explaining, worksheet consists of 140 rows I need to insert that data above the footer of the last page that is going to...
  5. E

    Dynamic Contents Page with Page Numbers

    Hi All, I am new to VBA and am really struggling to work this one out. I am creating a document in excel which I want when printed to look like a normal word document or PDF. So far the formatting for this is going well but I have found a hiccup when trying to create a Table of Contents sheet...
  6. T

    VBA Different first page/odd page header/footer

    I'm working on a sheet that spans two pages, and I'm trying to format the page setup in VBA (as the culmination of a number of other operations the macro is executing). Since the result is on only two pages, it doesn't matter to me whether it's odd/even pages or different first page. In my page...
  7. M

    Inserting a picture in the header in each sheet based on the sheet name

    Hi, I have around 250 sheets in a workbook all with a unique sheet name. I have 250 unique pictures (custom border templates) that correspond to the sheet name which I would like to insert into the header. How could I do this without manually going into each sheet inserting the picture and...
  8. O

    Document Header and Footer images placed in exact locations in bulk

    Hi guys, I'm currently changing the logos in bulk for 1000s of documents and know there to be an easier way to do this. I have some template documents which contain the right header and footer placements for each of the images, but I, so far, have not been able to translate this into bulk...
  9. D

    Carriage return of text in a footer

    I have code that enters text in a footer, how do I force vba to enter a carriage return in the footer so the text is on more than 1 line?
  10. M

    Right Footer not displaying correct information

    I have a workbook where I allow the user to print certain sheets. (There are potentially 30 to choose from, and they can print as few or as many as they want.) They have the option of having the date & time appear on each sheet, in the right footer. The code places this info in the right...
  11. N

    VBA - Footer font colour with long date format

    Hello Mr Excel gurus, As the title says, I'm trying to make a simple macro to apply to a button, so I can update the footer details of a Worksheet. I can accomplish all of these steps individually, however when I manipulate the "font colour" property, I can't seem to get things to work with...
  12. S

    vba to auto fill day of week and date in left footer of each sheet when you go to print out

    Hello. I am looking for some vba code to add the day of the week to the below wording and to work when printing for all sheets in a workbook. Currently it says in the footer: Report Dated: 08/30/2019 Format for wording is: Bahnschrift SemiBold Font, SemiBold Font style and 9 size. Want it...
  13. D

    Check if printing entire sheet or just selection

    Good afternoon, I have a spreadsheet that is a continuous log of data with dates and times. I am dynamically changing the footer based on the user's selection and including the selected date range for the report as part of the footer. This is all working fine. What I would like to do is...
  14. P

    Report issue suppressing page Header and Footer on report footer

    My report's final item is a chart image which is in the report footer. I don't want the page header and footer displayed here. I thought it would be easy - I set the report properties Page Header and Page Footer to "Not with Rpt Ftr". But although that works for printing (i.e. exporting to PDF)...
  15. 1

    Too many pages

    I've got an eleven page doc that all of a sudden has 6,941 pages. I only noticed it because the footer reads "Page X of 6941". How does this happen and how do I change it??
  16. R

    VBA headers and footers

    Hi All I would like to have 6 cells in a sheet with each one representing a position. I would like the header and footer on every sheet to reference what's in each cell. Possible? Thank you!
  17. I

    Non-sequential Page Number total in Excel Footer?

    Hi, I would like to know if there is a way to have Page # of # on the footer for each tab when printing? currently we have Page &[Page] of &[Pages] in the custom footer, but unless we print or export each tab individually to PDF it ends up with Page 1 of {total number of pages in workbook} Would...
  18. M

    VBA issue of Excel bug?

    Hi all! I need your help and expertise once again. The macro in this worksheet links cell B2 to the footer. So when you type into cell B2, it updates the Footer (and places whatever text you just typed into cell B2 into the left Footer location). Problem is, when I type into B2 and press...
  19. J

    Print portion of file path and tab name as footer automatically on ss

    I need to do two things, on ss open, ask if you want to print the filename ( see below) if yes, then 2. Print the file name and the last two folders going left plus the tab name oas footer in spreadsheet. for esxample if the path is x: jsh\nw\ HOUSTON\AREAS.XLS,then the filename that would...
  20. U

    VBA: Change Footer Logo Image (Right Section)

    Hi Guys, I have this task which I need to update the logo image which is usually do the same for 8 tabs. I tried highlighting all the tabs but in some way it affects the formatting of the macro enabled worksheet I'm using. 8 Tabs : Results, Summary, Students, Room, Subjects, Trainor, Schedule...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back