Forum Discussion

Copper Contributor

Jun 26, 2018

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?

Bronze Contributor

Jun 26, 2018

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

Bronze Contributor

Jun 26, 2018

addendum:
change A & E with your hidden columns..