+ Reply to Thread
Results 1 to 12 of 12

making a column invisible

  1. #1
    Registered User
    Join Date
    02-27-2024
    Location
    Germany
    MS-Off Ver
    Microsoft office 365
    Posts
    29

    making a column invisible

    I would like to make a column only visible to some.
    Attached Files Attached Files
    Last edited by Bailymaus; 03-28-2024 at 05:46 AM.

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,423

    Re: making a column invisible

    pls try this code
    Please Login or Register  to view this content.
    Last edited by wk9128; 03-25-2024 at 11:16 PM.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: making a column invisible

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: making a column invisible

    @Logit: why have you made this a loop? And shouldn’t Columns(i) be .Columns(i) ?

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: making a column invisible

    Yes, it should be .Columns(i) where applicable.

    However, here is an edited version :

    Please Login or Register  to view this content.

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: making a column invisible

    This lines of code
    Quote Originally Posted by Logit View Post
    Please Login or Register  to view this content.
    why not use:
    Please Login or Register  to view this content.
    Quang PT

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: making a column invisible

    Definitely another method of accomplishing the same thing. I designed my "Select Case" from habit. Thank you for providing
    the alternative.

  8. #8
    Registered User
    Join Date
    02-27-2024
    Location
    Germany
    MS-Off Ver
    Microsoft office 365
    Posts
    29

    Re: making a column invisible

    I would like to sat thank you to all that have contributed. As my skills are limited, I need time to muddle through this information.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: making a column invisible

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

    Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: making a column invisible

    Thanks for the rep.

  11. #11
    Registered User
    Join Date
    02-27-2024
    Location
    Germany
    MS-Off Ver
    Microsoft office 365
    Posts
    29

    Re: making a column invisible

    Thx for the reminder.

  12. #12
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,423

    Re: making a column invisible

    @Bailymaus You're Welcome. Glad to help . Thank You for the feedback and rep.

+ 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. Making specific workbook invisible
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2020, 02:56 PM
  2. VBA to Change all Red font to ;;; making it invisible
    By lathamashly in forum Office 365
    Replies: 2
    Last Post: 12-10-2018, 11:46 AM
  3. Making a combobox visible or invisible
    By Mientje08 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-04-2018, 10:15 AM
  4. Making a cell invisible but not delete it
    By Bartman888 in forum Excel General
    Replies: 5
    Last Post: 07-31-2018, 10:23 AM
  5. Rows making everything invisible
    By deviantone in forum Excel General
    Replies: 1
    Last Post: 08-27-2013, 11:19 PM
  6. Making rows invisible with VBA
    By Jimbozeubuen in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-08-2010, 06:28 AM
  7. Making Macro actions invisible
    By Ramin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-26-2009, 04:54 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