Public Variable Declaration Problem

[Ark68]

I have variable ws_form declared publicly as a worksheets at the workbook level of my code.
In the workbook open event, I set the variable:

Private Sub Workbook_Open()
    Set wb_demo1 = Workbooks("demo1.xlsm")
    Set ws_form = wb_demo1.Worksheets("Form")
End Sub

At the end of my workbook open code, if I check to see if the variable has been declared properly, ws_form.name does return a result of "Form"

I have code in my userform button that refers to actions needed on worksheet "Form".

Private Sub btn_proceed_Click()
    Unload Me
    With ws_form
        .Unprotect
        .Range("O3").Value = emplnum
        .Range("O4").Value = eqtnum
        .Activate
        .Protect
    End With
End Sub

At this point, it appears as though I have lost the association of ws_form with worksheets("Form"). If I test ws_form.name, I get an Object required error. If I've declared ws_form globally through the PUblic declaration, shouldn't it be retained throughout the project? Any idea why I Have lost it?

 

[Fluff]

Global variables need to be declared in a standard module.

 

[Ark68]

I see, thanks Fluff!

 

[Fluff]

You're welcome.