Forum Discussion
Settings to apply to automatically hide columns
Hello, I often have to export data from ministerial software and there are a lot of unnecessary columns. I cannot select the columns to export, the software only allows me to export all the colum...
Hi,
With a userform, columns on the sheet can be easily hidden and shown. This userform contains a listbox ,a combobox and a checkbox control.
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.