Results 1 to 10 of 10

Hide rows only on specific worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    12-21-2012
    Location
    Eden Prairie, MN
    MS-Off Ver
    Excel 2010
    Posts
    39

    Hide rows only on specific worksheets

    Hi All -

    I need help with VBA code to hide rows but only on specific worksheets. I'm not sure if a "case" statement is the way to go about acheiving this,but I tried it and it would only work on the first sheet. I know I'm missing something, just can't figure out what.

    The following code should be performed on all worksheets:
                            Columns("A:A").EntireColumn.AutoFit
                            Range("B10:E10,G10:I10,K10:N10,P10:S10").Select
                            Range("P10").Activate
                            Selection.ColumnWidth = 10.29
                            Range("F10:F10,J10:J10,O10:O10").Select
                            Range("O10").Activate
                            Selection.ColumnWidth = 1.71
                            Rows("47:68").Select
                            Selection.EntireRow.Hidden = True
                            Range("77:77,81:81,85:85").Select
                            Range("A85").Activate
                            Selection.RowHeight = 6
                            Module1.Freeze_Panes_B12
                            Range("A1").Select
    And this code should only be performed on these worksheets: "Policy Administration", "Policy Issue", "App Processing Services", "Underwriting Decisions", "Initial Claims", "Ongoing Claims Administration", "Claims Examinations"
                            Range("15:15,20:20").Select
                            Range("A20").Activate
                            Selection.EntireRow.Hidden = True
    Last edited by MissaLissa; 04-14-2014 at 12:24 PM. Reason: spelling

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide All Worksheets Except Specific
    By Kris in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-26-2014, 03:45 AM
  2. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  3. Hide specific Rows
    By Jakes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2012, 05:22 AM
  4. Need macro to check values and hide/unhide specific worksheets
    By amsnss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2011, 01:53 PM
  5. Hide all rows where one specific cell in that row = 0?
    By jaydevil in forum Excel General
    Replies: 2
    Last Post: 08-26-2005, 09:48 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