Question

How can I make my Excel userform pull data from a "veryhidden" ( I enabled this when I get into the VBA interface) Excel shee OR how can I lock certain coulmns so user cannot delete the data because my userform uses that data for combo box?
I tried both methods but when I click submit on userform, it goes to the Excel sheet that it needs to put the userform information,but I get an error and it doesn't paste the userform info.

What do you mean by your comment?

Are you saying the sheet doesn't exsit because it is "very hidden", therefore it can't pull the data?

Answer 1

an Excel sheet can be visible or hidden. As a matter of fact, there are two levels of worksheet hiding: hidden and very hidden.

Unhiding a sheet that was hidden normally is very easy. All you have to do is right-click any visible worksheet, click Unhide, and select the sheet you want to view. Very hidden sheets are a different story.

By the Visible property of the sheet, which can have one of these values:

• xlSheetVisible (or TRUE) - the sheet is visible
• xlSheetHidden (or FALSE) - the sheet is hidden
• xlSheetVeryHidden - the sheet is very hidden

We can make the worksheet hidden by changing its visible property . and we can also do this by using VBA
Eile Edit View Insert Format Debug Run Project -VBAProject X VBAProject (Book1.xlsx) Microsoft Excel Objects Sheet1 (Sheet 1) Sheet2 (Sheet2) Sheet3 (Sheet3) Sheet4 (Sheet4) Sheet5 (Sheet5) ThisWorkbook Properties - Sheetl Sheet1 Worksheet Alphabetic Categorized |Name) DisplayPageBreaks DisplayRightToleft EnableAutoFilter EnableCalculation EnableFormatConditionsC True EnableOutlining EnablePivotTable EnableSelection Name ScrollArea StandardWidth Visible Sheet1 False False False True False False 0 xINoRestrictions Sheet1 843 SheetVeryHidden -1-xISheetVisible 0-xISheetHidden 2-xISheetVeryHidden Immed X

Sub VeryHiddenActiveSheet () Activesheet.visible xlsheetVeryHidden = End Sub

Unhide all very hidden sheets with VBA If you have quite a lot of very hidden sheets and you want to make them all visible again, this macro will wor treat Sub UnhideVeryHiddenSheets ( ) Dim wks As Worksheet For Each wks In Worksheets If wks.Visible xlsheetVeryHidden Then wks.Visible xlsheetVisible - Next End Sub

Sub UnhideAllsheets () Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets wks.Visible Next wks xlsheetVisible End Sub
code . image examples giving both the methods have been provided.