+ Reply to Thread
Results 1 to 2 of 2

Macro for a specific print setting Unsolved

  1. #1
    Registered User
    Join Date
    11-20-2020
    Location
    Unit 2D Yonkers
    MS-Off Ver
    MS-office
    Posts
    1

    Macro for a specific print setting Unsolved

    Hi. I have to print different word documents and their spacing to the top of the page is either 2.5cm or 4.5cm. We have to print the documents on different types of paper and with hidden text enabled for our intern copies so I made a little macro. But the macro either applies the 2.5cm spacing or the 4.5cm spacing. I have to seperate macros now, but I want to mash them into one. Best way to do it, would be to read the setting (TopMargin = CentimeterToPoint (X)) and apply an if else condition to either the one or the other version. Is this possible?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,009

    Re: Macro for a specific print setting Unsolved

    .
    There most likely is a solution BUT ... you need to post your code and if possible a copy of your workbook WITHOUT confidential data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Unsolved - * Print Problem
    By lenovo007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2017, 04:47 PM
  2. Replies: 1
    Last Post: 08-06-2012, 04:56 PM
  3. Setting print area in a macro
    By pkenard in forum Excel General
    Replies: 4
    Last Post: 03-02-2012, 06:32 PM
  4. Macro for setting Print Area
    By Pat Parker in forum Excel General
    Replies: 0
    Last Post: 02-07-2012, 11:25 AM
  5. Setting Specific Cells To Not Print
    By Jeremy.Whitney in forum Excel General
    Replies: 2
    Last Post: 07-30-2006, 09:20 PM
  6. [SOLVED] Setting print area within macro
    By TimMalone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2005, 10:35 AM
  7. [SOLVED] Setting up a macro to print?
    By Abi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1