Forum Discussion
kwlambeth
Jun 26, 2018Copper Contributor
Unhide columms???
I hide columns and made some changes to the document. Saved the doc and when I came back later the columns are still hidden. How do I unhide them?
Lorenzo Kim
Jun 26, 2018Bronze Contributor
Kwlambeth
If you want it to automatically unhide then you need vba to do this, like my project.
Inside ThisWorkbook: Private Sub Workbook_Open()
insert - Range("A:E").Select (this selects columns A to E)
Selection.EntireColumn.Hidden = True
Hope this helps
Lorenzo Kim
Jun 26, 2018Bronze Contributor
addendum:
change A & E with your hidden columns..
change A & E with your hidden columns..