+ Reply to Thread
Results 1 to 3 of 3

Hide columns in multiple worksheets based on one cell.

  1. #1
    Registered User
    Join Date
    09-28-2011
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    7

    Hide columns in multiple worksheets based on one cell.

    Hi all.

    This is my situation:
    I got a few sheets with various information and I want to hide some of it based on the value of a cell in the first sheet. I got this working just fine on a single sheet with alot of help from this thread.
    http://www.excelforum.com/excel-prog...of-a-cell.html

    But like I said, I ant it to work on other sheets aswell. I am new at this so I would love some help.
    I dont know what I should add to the code, or if I should make a brand new one.

    Thanks in advance.
    Last edited by -Johan-; 10-03-2011 at 02:37 AM.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Hide columns in multiple worksheets based on one cell.

    Hi
    I've amended the code from the thread link you supplied. It was a great help. This amendment will hide multiple columns on Sheets 2 and 3 of a workbook. You can add whatever sheets you wish.

    Please Login or Register  to view this content.
    This hides the columns. You will need other code to unhide them or do it manually.

    Hope this helps

  3. #3
    Registered User
    Join Date
    09-28-2011
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Hide columns in multiple worksheets based on one cell.

    Thanks a million DBY =)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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