Posts by jbow11

    Re: VBA Hide Columns Based on Date


    I noticed when deleted my macro before, I accidentally removed the macro for unhiding the hidden columns (just in case I wanted to compare previous months). Would you happen to know some VBA for opening up just those columns?


    Thank you very much for your help so far! It works exceptionally.

    Re: VBA Hide Columns Based on Date


    How exactly would I input the VBA code properly?
    I opened the VBA editor panel, and attempted to put it under the Class Module opened by excel when I created the button.
    [ATTACH=CONFIG]68567[/ATTACH]
    This is what my spreadsheet currently looks like:
    [ATTACH=CONFIG]68568[/ATTACH]
    I'm sorry, I'm just really new to VBA (and to be brutally honest its been a few years since I've really done any real programming).

    Hey!


    I am very new to VBA, and macro coding. I have tried finding solutions for what I am attempting to do in excel.


    I am currently using the 2016 Mac Version of Excel with the project I am working on, so compatibility across platformed versions of Excel is a highly desired goal with this coding project.


    My Current Project is attempting to use a form button to toggle which columns are active (Unhidden) and those which are inactive (hidden). I already was able to create another button for the spreadsheet which toggles all columns to unhidden state, however I am having difficulty with creating the necessary VBA code for my other button.


    The Criteria is, the page automatically determines the current month by using the =month(today()) formula to display both text (cell B3) and the serial number of the month (cell B2).
    This information is important as it is the filter for the button toggle. The goal is to create a button which will hide all columns displaying months which are not the current month.


    The Column Ranges I have are Jan(C:C);Feb(D:D);Mar(E:E);Apr(F:F);May(G:G);Jun(H:H);Jul(I:I);Aug(J:J);Sept(K:K);Oct(L:L);Nov(M:M);Dec(N:N).