Forum Discussion

Iron Contributor

Mar 12, 2021

Question related to hidden sheet in excel VBA

Hello Everyone, Suppose i have sheet. And i hide the ZAN sheet Like - When i run the code, then i select ZAN sheet in dropdown Like - Then it give me error. like - ...

ZanQuarterlyReportForm-01.xlsm39 KB

Macros and VBA

HansVogelaar

MVP

Mar 12, 2021

Excel

Change the UserForm_Initialize event procedure like this:

Private Sub UserForm_Initialize()
    Dim wsh As Worksheet
    For Each wsh In Worksheets
        If wsh.Visible = xlSheetVisible Then
            Me.cboWhichSheet.AddItem wsh.Name
        End If
    Next wsh
End Sub

Excel

Iron Contributor

Mar 12, 2021

Hello Sir,
Thank you so much sir😊😊