locked
vba for Alt text remove space at the end of each page RRS feed

  • Question

  • Hi

    I am looking for code to apply alt text to whole document (200 pages), this include financial tables. Also can I also add vba code to remove space in the end of each page. Grateful for any help!

    Friday, February 16, 2018 9:51 PM

All replies

  • The ShapeRange.AlternativeText Property applies to shape objects, not to text ranges. Similarly, the Table.Title Property and the Table.Descr Property apply to tables, not to text ranges. AFAIK there is no Alt text property for a whole document. Perhaps you're thinking of one of the built-in document properties?

    As for "vba code to remove space in the end of each page", that's impossible to address without knowing what is causing that spacing to appear. There is any number of possibilities. In any event, the page layout to some extent depends on what the active printer is. Consequently, a given page may be 'full' when one printer is in use, but not so when another printer is in use.


    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Proposed as answer by Charles Kenyon Saturday, February 17, 2018 4:42 AM
    Saturday, February 17, 2018 12:43 AM
  • For the space at the end of pages, start with Improving the Bottom Line to see what Paul is talking about.

    Charles Kenyon Madison, WI

    Saturday, February 17, 2018 4:45 AM
  • Hi, 

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    Regards,

    Emi


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, February 19, 2018 5:24 AM