Results 1 to 7 of 7

Hide Column If Cell Value is empty from Checkbox

Threaded View

Guple Hide Column If Cell Value is... 04-08-2014, 10:09 AM
patel45 Re: Hide Column If Cell Value... 04-09-2014, 12:57 AM
Guple Re: Hide Column If Cell Value... 04-09-2014, 07:14 AM
patel45 Re: Hide Column If Cell Value... 04-15-2014, 04:40 AM
Guple Re: Hide Column If Cell Value... 04-15-2014, 04:21 AM
Guple Re: Hide Column If Cell Value... 04-09-2014, 04:01 AM
Guple Re: Hide Column If Cell Value... 04-15-2014, 04:20 AM
  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    SWE
    MS-Off Ver
    Excel 2011
    Posts
    15

    Hide Column If Cell Value is empty from Checkbox

    Hi,

    I´m looking for a macro were i could filter columns based on its cell value in a specific row (5) with a checkbox placed in row 5. So for example if a column in this specific row 5 is empty then it should be hidden when the checkbox is ticked. The sheet containt multiple rows with the same function, which makes it a little complex. If the same column, in row 6 contains a value, then the coloumn should not be hidden even though checkboxes from row 5 and row 6 is ticked.

    There is also 2 specific columns that should be independent and should not be hidden in any case.

    I have tried many codes with the best i could was to hide all columns even though they contained a value....


    Pleases se attachment.

    Best regards, Guple
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide rows if cell in Column E is empty
    By annemsauro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2013, 02:27 PM
  2. VBA help if the checkbox is selected hide/unhide column
    By bgreen66 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2013, 03:39 PM
  3. [SOLVED] Tick checkbox if a certain cell is not empty.
    By jazzy747 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-12-2012, 05:43 PM
  4. Macro Required - Hide columns where cell in a single column is empty
    By heatwave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2012, 12:53 AM

Tags for this Thread

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