[RESOLVED] Application ScreenUpdating=false not working on userfrom_activate

[ColdBore]

Gurus

My problem:When the "Transer" userform is activated the user can view actions being performed on the sheet "Stored" (xlVeryHidden) which I do not want visible.

I have a userform "Transfer" that is called from userform "PartsListTrans":

Private Sub PartListTrans_Click()
Unload TransSupp
Transfer.Show
End Sub

This is the code for Transfer userform

Private Sub UserForm_Activate()
Application.ScreenUpdating = False
ActiveWorkbook.Worksheets("Inventory").AutoFilterMode = False


Sheets("Stored").Visible = True
'clears columns A
Sheets("Stored").Select
Columns("A").Select
Selection.Delete
'This puts the value from a cells on inventory into into TextBox1 _
when the userform is activated
Dim ws As Worksheet
Set ws = Worksheets("Stored")
TextBox1.Value = ws.Range("b1").Value
TextBox2.Value = ws.Range("b2").Value
TextBox3.Value = ws.Range("b3").Value


End Sub

Thanks ahead of time for any assistance.

[vbfbryce]

Could you make the sheet invisible when the workbook opens?

[ColdBore]

That's correct the sheet is VeryHidden when Workbook opens. I only need it open for this single userform. It needs to remain VeryHidden after the routine is complete.

[westconn1]

you could try to set screenupdateing to false before userform.show

[ColdBore]

No that didn't work either westconn1. I moved screenupdating around to various lines in "Private Sub PartListTrans_Click() "Private Sub UserForm_Activate()" I also moved some of the lines of userform_Activate() to PartsListTrans_Click() with screenupdating=false but results are the same , work on sheets "Stored" is always visible.

[vbfbryce]

You don't need to unhide it when the form activates. Here's an example:

Private Sub UserForm_Activate()
    Dim ws As Worksheet
    Set ws = Worksheets("Sheet1")   'my hidden sheet
    With ws
        .Range("c1:d1").Delete
        Me.TextBox1.Text = .Range("b2").Value
        Me.TextBox2.Text = .Range("b3").Value
    End With
End Sub

[ColdBore]

Vbfbryce , that was the solution, no need to unhide the sheet. Thank you everyone for the help!!!