• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unable to set the visible property of a worksheet class

alleyk

New Member
First, let me mention I am very inexperienced in Visual Basic.
I have 9 worksheets in my workbook, 6 of which are hidden at times. My macros to open them when hidden are coded as follows:

Sheets("Competitor Entry").Select
If Range("T6") = "A1" Then
Sheets("A = Sparring 3 Comp").Visible = True
Sheets("A = Sparring 3 Comp").Select
Range("G14").Select

The hide and unhide features have been working without issue until I tried to protect the workbook structure. These hidden sheets were not protected sheets. Once I protected the workbook structure, the sheets would no longer become visible.
First the macro returned the error above when I ran it.
I clicked on a visible tab and tried to unhide the hidden sheets but that option was not available.
I then unprotected the structure (and all sheets) in the workbook with the same result.
Finally, I went into VBA and tried to change the property to visible for these sheets but it would not allow it.

What do I try now! Please help!
 
Back
Top