With a VBA userform, columns on the sheet can be easily hidden and shown. Sheets of workbook are listed in combobox .With this combobox can be navigated between sheets of workbook. The used columns in the selected sheets are listed in the listbox along with the column headings.

The selected columns from the listbox are hidden.

You can review userform here