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).