How to access hidden sheets
How to access hidden sheets
(OP)
I've looked at thread 770-139249 for some help but I need more assistance. I have a couple of sheets that are hidden and they are set to "0 - xlSheetHidden" in the VBA project editor and when I try to set them to "-1 - xlSheetVisible, I get an error "Unable to set the Visible property of the Worksheet class".
I've also looked at Excel help sites on the Web and still no help. Any ideas?
I've also looked at Excel help sites on the Web and still no help. Any ideas?





RE: How to access hidden sheets
RE: How to access hidden sheets
On Excel 2007/2010, Home Ribbon, Format/Hide & Unhide
RE: How to access hidden sheets
Sub PasswordBreaker()
'Author unknown but submitted by brettdj of www.experts-exchange.com
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
This gave me access to the formulas, but not to the sheets that have the data used in the calculations.
RE: How to access hidden sheets
http://www.excel-university.com/make-an-excel-work...
RE: How to access hidden sheets
RE: How to access hidden sheets
Did you run your PWBreaker on the worksheet or the workbook? Both can be protected with different PWs.