+ Reply to Thread
Results 1 to 4 of 4

Hide Columns Macro not working - Help?

  1. #1
    Registered User
    Join Date
    03-09-2012
    Location
    N/A
    MS-Off Ver
    MS 365
    Posts
    70

    Exclamation Hide Columns Macro not working - Help?

    Hi folks,

    I've written a macro to hide certain columns depending on which month is selected from a drop-down menu

    e.g.

    If Jun-13 is selected, I would like the following columns to be visible:

    D, E, F, G, I, K, M, O, Q, R, Y, Z, AA, AB

    so that effectively we show all the preceding months actuals (ACT), Jun-13 actual & budget, always show Columns Y, Z, AA, AB regardless of which ever month is selected, e.g.

    If Aug-13 is selected, I would like the following columns to be visible:

    D, E, F, G, I, K, M, O, Q, S, U, V, Y, Z, AA, AB

    I need a resolve pretty urgently so any help really appreciated

    Thanks, Maddy :-)Hide_Col_Example.xlsm
    Last edited by overbomb; 06-30-2013 at 11:52 AM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Hide Columns Macro not working - Help?

    Hi, overbomb,

    please look at C8 for a check (not C6 which is empty).

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    03-09-2012
    Location
    N/A
    MS-Off Ver
    MS 365
    Posts
    70

    Re: Hide Columns Macro not working - Help?

    thank you :-) knew I was missing something simple but just couldn't see it

    ciao

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Hide Columns Macro not working - Help?

    Hi, overbomb,

    in your code you may combine some columns to sort of shorten the code:
    Please Login or Register  to view this content.
    Ciao,
    Holger

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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