+ Reply to Thread
Results 1 to 3 of 3

Hide Columns In Different Worksheet When Dropdown Value Is Selected

  1. #1
    Registered User
    Join Date
    08-18-2013
    Location
    Wembley
    MS-Off Ver
    Office 365
    Posts
    49

    Hide Columns In Different Worksheet When Dropdown Value Is Selected

    Hi

    Can someone provide me with the VBA code that will hide certain columns in another worksheet when I select a certain value in a data validation list?

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Hide Columns In Different Worksheet When Dropdown Value Is Selected

    Your question is extremely vague so the response will be as equally vague. This accomplishes what you have asked for but you will obviously have to modify to suit your needs:

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.

  3. #3
    Registered User
    Join Date
    08-18-2013
    Location
    Wembley
    MS-Off Ver
    Office 365
    Posts
    49

    Re: Hide Columns In Different Worksheet When Dropdown Value Is Selected

    Vague is good sometimes. Your answer is perfect.

    Thank you.

+ 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] VBA to hide multiple rows when a particular value is selected from the dropdown
    By varmoh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-18-2015, 10:47 AM
  2. Hide Columns Dropdown Menu
    By Viktor86HUN in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 11-25-2013, 07:43 AM
  3. Dropdown box to hide various number of columns
    By gherzberg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2012, 05:57 PM
  4. Replies: 0
    Last Post: 09-13-2012, 03:53 AM
  5. Hide/Unhide rows on multiple sheets when dropdown selected from sheet 1
    By tammhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2012, 10:33 PM
  6. To unhide columns depending on which dropdown is selected
    By Biffa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2012, 01:21 PM
  7. Hide columns based on dropdown value
    By DaveNUFC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2010, 04:36 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