VBA to unhide a column when opening a workbook

Question

To give the user the choice of viewing only the data they need and when they need it, my user form contains two buttons: one to unhide column A and another one to hide column A. Below is the code for this.

  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

But every time the user opens the workbook, I want column A to be visible (unhidden) by default. For instance, even if the user saves the workbook with column A hidden, I want column A to immediately be displayed by default the following time the same spreadsheet is opened. I'm not sure how to change the above VBA to accommodate that. We would appreciate any assistance.

Answer 1

Use the workbook_open even within ThisWorkbook.