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
Private Sub OptionButton4_Click()
'UnHide column A
Worksheets("Page1").Columns("A:A").Hidden = False
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.