+ Reply to Thread
Results 1 to 2 of 2

Macro to show only specifik table

  1. #1
    Registered User
    Join Date
    08-09-2016
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    20

    Macro to show only specifik table

    I have table1 -> table6

    I wanna insert 6 buttons that lets the user only view a specifik table at a time (and a show all button)

    Is this possible? The problem is they are expanding, so I cant just do a hide/shows a A9:F1555-kindda-macro

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,630

    Re: Macro to show only specifik table

    Are the tables next to each other, above each other, or on separate worksheets? Do they have blank rows or columns in between them? Are they Structured Tables?

    Suggest you post a Sample workbook with some typical data.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. [SOLVED] Macro to search table and show row info
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-15-2016, 10:52 PM
  2. [SOLVED] Macro to save sheet specifik place, with 2 cellvalues as name
    By horsefish01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-27-2016, 01:15 PM
  3. Macro run on specifik day/time
    By horsefish01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2016, 04:41 PM
  4. Pivot table show details macro
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-27-2012, 11:15 PM
  5. Macro or Pivot Table to show monthly totals
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2010, 10:29 AM
  6. Macro to show pivot table details..Any ideas?
    By Poison990 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-26-2009, 01:14 PM
  7. table to show the average price macro
    By vaseny in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2008, 09:42 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