I would like to create a macro that, upon opening the
file, looks at each cell in Row two and if that cell has
the term "hide" then the macro will hide that column and
for every column in the range.

Column 1 2 3 4 5 6

row 1 SF LA NY Chi Bos Cle
row 2 hide view hide view view view

Any suggestion on how to code this?

Thank you.