V
vow.jackofhearts
I have created a spreadsheet that contains several buttons for
different views. Each of these buttons runs its own vba macro that
hides certain columns in the spreadsheet. I am trying to figure out
how I can set this up so that if a user adds a new column to the
spreadsheet, it still hides the same columns. For example, I have
columns A,B,C,D, and E. I have a macro that hides column C. If a
user adds a new column to the beginning of the spreadsheet, I want
that button to still hide the old column C (now column D). Any
thoughts on how I could do this?
different views. Each of these buttons runs its own vba macro that
hides certain columns in the spreadsheet. I am trying to figure out
how I can set this up so that if a user adds a new column to the
spreadsheet, it still hides the same columns. For example, I have
columns A,B,C,D, and E. I have a macro that hides column C. If a
user adds a new column to the beginning of the spreadsheet, I want
that button to still hide the old column C (now column D). Any
thoughts on how I could do this?