+ Reply to Thread
Results 1 to 12 of 12

printing code

  1. #1
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    printing code

    Hi, I am after a code that will sort out the below printing problem


    I want excel to hide column E from the printer, i want to see the information myself but when i press print column E will not show



    http://www.excelforum.com/excel-new-...ml#post2034148

    that is the orignal problem

    Thanks

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: printing code

    Take a look here

    http://www.rondebruin.nl/print.htm#Hide
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Re: printing code

    looks just what i need

    Please Login or Register  to view this content.

    how do i enter it?


    thanks
    Last edited by stokie21; 01-29-2009 at 05:15 AM.

  4. #4
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: printing code

    Right click on the sheet tab, go to "View Code"

    When the VBA editor opens, Paste the code

    Close the VBA editor

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: printing code

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  6. #6
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Re: printing code

    dont work, it must be something i am doing can anyone confirm the code is correct

    Thanks

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: printing code

    Thanks for taking the time to read and comply with the rule .

  8. #8
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: printing code

    Is the sheet you're trying to print called Sheet1 ?

  9. #9
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Re: printing code

    yes i think so, i have put it in both

    \1

  10. #10
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: printing code

    Attach the workbook not an image

  11. #11
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Re: printing code

    how do i upload it?


    [attach]DAiIe.xls[/attach]

  12. #12
    Registered User
    Join Date
    12-05-2007
    Posts
    24

    Re: printing code

    here is the sheet I want excel to hide column E, this is where i will enter my retail price and i dont want the printer to see it


    Thanks
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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