+ Reply to Thread
Results 1 to 2 of 2

Hiding a Column - LockedSheet

  1. #1
    Registered User
    Join Date
    01-30-2015
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2013
    Posts
    7

    Hiding a Column - LockedSheet

    Hello everyone!

    Can you please help me fix this formula.

    The idea of the formula is to hide specific columns in the sheet depending on the cell value. It also unprotects the sheet and when its done protects it again. Everything is ok except that when i type 3 it hides only column H and not H,I and J, when i type 2 it hides only I and not I and J and when i type 1 it hides J just as it should.



    Please Login or Register  to view this content.
    If there's a way to shorten the code i'll be happy
    Thank you in advance!
    Last edited by TrafficNET; 08-07-2020 at 05:39 PM.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Hiding a Column - LockedSheet

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. I need the code for hiding a column if a cell in that column has no date.
    By Martynoxon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 11:17 AM
  2. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-30-2011, 09:24 AM
  3. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2011, 06:49 AM
  4. Using Drop down list to show column A while hiding column B
    By glee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2011, 12:41 PM
  5. Inserting new column, hiding oldest column, 12-month total
    By ambiewaq in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2010, 12:39 PM
  6. Hiding Column Also hiding text
    By Cindy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2006, 02:20 PM
  7. [SOLVED] Need help hiding/unhiding column based on autofilter selection in a different column
    By kcleere in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2006, 02:25 AM
  8. Replies: 2
    Last Post: 10-18-2005, 10:05 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