+ Reply to Thread
Results 1 to 4 of 4

Excel Table Print Filter Buttons

  1. #1
    Forum Contributor
    Join Date
    01-07-2004
    Posts
    314

    Excel Table Print Filter Buttons

    Hi all,

    Using Excel 2013.
    I have an Excel Table (List) with filter buttons visible

    However, when I print part of the table to .pdf the filter buttons are not visible in the resulting .pdf.
    Is there an option to print the filter buttons?

    I tried to select the filter buttons to try to set the print property of the object, but that is not working.

    thx
    w
    Kind regards,
    w

    http://dataprose.org

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,568

    Re: Excel Table Print Filter Buttons

    I have no real idea on how to fix this, but perhaps include some "dummy" buttons - that dont actually do anything - that look the same as your macro buttons?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel Table Print Filter Buttons

    One thing that you can do is to activate the Camera Tool.....Click on the down arrow on the Quick Access Toolbar (QAT). Choose All Commands and scroll down to the Camera and add it to the QAT.

    Select the table and click the camera tool. The cursor changes to a cross. Draw a rectangle. The rectangle will not be proportional but don't worry about it. When you let go of the left button after drawing the rectangle, the picture of the table will appear and you can size it to suit. If you print, this picture will show the table complete with the buttons.

    The picture is linked to the original so changes you make are reflected in the "picture" with the exception of adding records. If you delete records they are deleted from the "picture".

    Hope this helps.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,684

    Re: Excel Table Print Filter Buttons

    Or

    Try the below UDF.
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    After installing the code in a new module you just return to excel and press = and type AfStatus(Cell_Ref).

    Of course you can use it in CF too... Refer the attached file for details

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. Multiples table on sheet, help with print and filter
    By swiftrain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2013, 12:20 AM
  2. Macro to print each name in a pivot table filter drop-down on a seperate page
    By Tamarissa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2012, 02:28 PM
  3. Adding Filter Buttons to a Pivot Table
    By bakes1 in forum Excel General
    Replies: 2
    Last Post: 04-09-2008, 04:24 PM
  4. Excel buttons to print out on pdf file and printer!!
    By umitakkaya in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2006, 10:10 AM
  5. [SOLVED] Excel Bug Moves Cmd Buttons When Print
    By BlackbeltDomains.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2005, 03:05 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