Excel VBA Column Management (Hide & Unhide)

          Excel Hide Columns With Userform

         In this template ,the userform opens automatically when workbook is opened and userform is displayed in the upper right corner of the screen.
Private Sub UserForm_Activate()
Dim syf As Integer
With Me                                     
    .Left = (Application.Width - .Width) - 7
    .Top = 0
End With>
End Sub
         Sheets of workbook is added to drop-down list. Can be navigated between pages with this drop-down list.
         The used columns of sheets with column headers are listed on the listbox based on selected sheet from drop-down list. The selected columns from listbox are hidden. All items of listbox can be selected with checkbox at same time.

excel hide column

You can easily add own excel file this userform and can use it. For this :
Close userform .
 Press Alt +F11 keys to open VBE (Visual Basic Editor) Window .
 Open your own file .
 Drag module and userform in this template to the part of your own files .
 Save changes and restart your file.

No comments:

Post a Comment