title: vba to unhide a column when opening a workbook
body: <p>My user form has two buttons, one to unhide column A and another one to hide column A to give the user the option of seeing only the data they need and when they need. The code for this is below.</p>
  
  <pre><code>  Private Sub OptionButton3_Click()
    'Hide column A
    Worksheets("Page1").Columns("A:A").Hidden = True
    End Sub
  
  
    Private Sub OptionButton4_Click()
    'UnHide column A
    Worksheets("Page1").Columns("A:A").Hidden = False
    End Sub
  </code></pre>
  
  <p>However, I'd like column A to be visible (unhidden) by default every single time the user opens the workbook. For example even if the user saves the workbook with column A being hidden, I want that next time someone opens the same spreadsheet to have column A visible automatically by default. I'm not sure how to amend the vba above for that. Any help much appreciated? Thanks </p>