+ Reply to Thread
Results 1 to 9 of 9

Need to remove dropdown arrows from Print out

  1. #1
    Forum Contributor
    Join Date
    08-31-2007
    MS-Off Ver
    2010
    Posts
    130

    Need to remove dropdown arrows from Print out

    I have created a form using a number of Drop Down boxs.
    I want to be able to print the form but would like to clean
    the printout up by removing the arrows from the printed page.
    Is there a simple way to do this?

  2. #2
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Need to remove dropdown arrows from Print out

    Drop down arrows shouldn't appear in the printout. I have many files that use drop downs and I print them out all the time just fine.

  3. #3
    Forum Contributor
    Join Date
    08-31-2007
    MS-Off Ver
    2010
    Posts
    130

    Re: Need to remove dropdown arrows from Print out

    Must be a setting then because mine are printing.
    When you said that I thought maybe it was just showing in the print preview
    But that is not the case I printed it out and the arrows all show up on the printout.

  4. #4
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Need to remove dropdown arrows from Print out

    Can you post an example file?

    I remember from old days there was an option to show/print "nonprint characters", perhaps that's what's messing it up for you.

  5. #5
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Need to remove dropdown arrows from Print out

    If you are using a combo box then try this.

    Right Click/Format Control/Properties
    Uncheck "Print Object"

  6. #6
    Forum Contributor
    Join Date
    08-31-2007
    MS-Off Ver
    2010
    Posts
    130

    Re: Need to remove dropdown arrows from Print out

    Unchecking "Print Object" removes the input from the printout.

  7. #7
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Need to remove dropdown arrows from Print out

    Oh... Whoops. I googled it, sorry.

  8. #8
    Forum Contributor
    Join Date
    08-31-2007
    MS-Off Ver
    2010
    Posts
    130

    Re: Need to remove dropdown arrows from Print out

    I have attached a one liner.
    If you go to print preview you will see thee Arrow is indeed going to be a part of the printout.
    I need the info included inside the box but not the arrow.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Need to remove dropdown arrows from Print out

    Found this also, but I don't know how to use it:

    ...in the code that does the printing, put something like

    ComboBox1.ShowDropButtonWhen = 0

    Can you use a drop down list created via Data Valdation? I use those and they print out nicely.

+ 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. remove dependent arrows? how and why?
    By wwwexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-27-2014, 11:23 PM
  2. [SOLVED] Tables and Filters - How to remove filter on table without removing little arrows?
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2014, 11:48 AM
  3. Remove duplicates and populate items based on dropdown
    By Dak! in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2014, 06:33 PM
  4. Remove selected options from dropdown list
    By Badking333 in forum Excel General
    Replies: 15
    Last Post: 11-26-2013, 10:49 PM
  5. Remove Green Error Arrows
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2012, 03:17 AM
  6. Remove Table Filter Arrows on some Columns
    By lipster in forum Excel General
    Replies: 1
    Last Post: 02-14-2010, 04:16 PM
  7. how can I remove a dropdown list from my worksheet
    By Boomer in forum Excel General
    Replies: 4
    Last Post: 04-04-2006, 11:10 AM

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