title: Hide columns in excel
body: <p>I am bit unsure whats the best way to hide columns in excel. I have a spread sheet with currently A to AL columns, but people keeps adding columns to it regularly.</p>
  
  <p>Then we have a few user groups, production, designer,sales,revison and so on.</p>
  
  <p>Depending on which usergroup the user is in, I would like to hide columns not relevant for the user. </p>
  
  <p>So my idea is that I could add a note to each column header with the text production,designer if that column is relevant for those two groups and so on. Then in vba loop through all columns and hide the ones not relevant. </p>
  
  <p>Hiding the columns are easy to achieve:</p>
  
  <p><code>With Range("C:C,F:H,S:AC")
    .EntireColumn.Hidden = true
  End With</code></p>
  
  <p>and then either in a hidden sheet or a text file specify group name and the usernames such as:
  <br>design:kim,peter,kevin<br>
  production:arild,roar</p>
  
  <p>Any ideas of how to best do this?</p>