Results 1 to 6 of 6

Thread: Excel 2013 Compatibility Mode
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2009
    Posts
    137
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel 2013 Compatibility Mode

    Morning,

    Acolleague has sent me an Excel Spreadsheet which was in compatibility mode.This has converted it to Excel 2013. The problem is that 8 rows at the top ofthe spreadsheet which were not previously viewable are now fully on display andwhatever I try to do to hide these rows it doesn’t appear to work. There arequite a few macros in the Spreadsheet which filters the data and these rowscontain the filters, can anyone advise what I can do to hide these rows so thatthe Spreadsheet resembles the original? TIA

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,055
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Excel 2013 Compatibility Mode

    Try

    Code:
    Sheets("SheetName").Range("A1:A8").EntireRow.Hidden = True
    
    Last edited by Yongle; Nov 16th, 2018 at 05:16 AM.

  3. #3
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,055
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Excel 2013 Compatibility Mode

    Or perhaps

    Code:
    Sheets("SheetName").Range("A1:A8").RowHeight = 0

  4. #4
    Board Regular
    Join Date
    Jan 2009
    Posts
    137
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel 2013 Compatibility Mode

    Hi Yongle,

    I have inserted a new module and inserted both lines you suggested and neither appear to work. Could you give any more details? TIA

  5. #5
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,055
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Excel 2013 Compatibility Mode

    Code:
    Sub HideRows
       Sheets("Sheet1").Range("A1:A8").EntireRow.Hidden = True
    End Sub
    Try the above code in a NEW workBOOK so that you can see that it works

    If the "problem" worksheet is protected - that could be preventing you from altering row visibility
    Last edited by Yongle; Nov 16th, 2018 at 08:59 AM.

  6. #6
    Board Regular
    Join Date
    Jan 2009
    Posts
    137
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel 2013 Compatibility Mode

    I did copy your code to a new workbook and it did work. I will have to try to find out what password was used, unfortunately the person who developed the spreadsheet has left the department.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •