+ Reply to Thread
Results 1 to 5 of 5

Can’t make columns automatically hide when cell in the columns <1

  1. #1
    Registered User
    Join Date
    11-29-2019
    Location
    California
    MS-Off Ver
    Excel
    Posts
    3

    Can’t make columns automatically hide when cell in the columns <1

    [Bob] [Joe] [Sam]
    [ 1 ] [ 1 ] [ 0 ]


    I would like to have the spreadsheet automatically hide, but not delete, Sam’s column. Any help will be appreciated, thanks.

  2. #2
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Can’t make columns automatically hide when cell in the columns <1

    Please Login or Register  to view this content.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  3. #3
    Registered User
    Join Date
    11-29-2019
    Location
    California
    MS-Off Ver
    Excel
    Posts
    3

    Re: Can’t make columns automatically hide when cell in the columns <1

    thanks for taking your time to help me! where do i enter that formula?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,855

    Re: Can’t make columns automatically hide when cell in the columns <1

    How to install your new code
    • Copy the Excel VBA code
    • Select the workbook in which you want to store the Excel VBA code
    • Press Alt+F11 to open the Visual Basic Editor
    • Choose Insert > Module
    • Edit > Paste the macro into the module that appeared
    • Close the VBEditor
    • Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)


    To run the Excel VBA code:
    • Press Alt-F8 to open the macro list
    • Select a macro in the list
    • Click the Run button
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Can’t make columns automatically hide when cell in the columns <1

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

+ 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] Automatically Hide or not Hide columns, based on cell value (to the left)
    By sherylt13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2018, 07:47 PM
  2. Automatically Hide Columns
    By xlsnovice in forum Excel General
    Replies: 2
    Last Post: 08-05-2013, 12:08 AM
  3. [SOLVED] Automatically Hide and Unhide Columns
    By A Parsons in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-03-2013, 01:15 PM
  4. Automatically hide columns and unhide of cell value(s) appear within a range
    By oddinho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2013, 08:32 PM
  5. How do I automatically hide columns?
    By PPM at Brackmills in forum Excel General
    Replies: 2
    Last Post: 02-10-2006, 01:00 PM
  6. How do I automatically hide columns in a worksheet based on a cell value?
    By dkhedkar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2005, 09:06 PM
  7. Replies: 0
    Last Post: 03-04-2005, 02:43 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