private sub worksheet_activate()
Application.ScreenUpdating = False
ActiveWindow.DisplayWorkbookTabs = False
With ActiveWindow
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
End With
ActiveSheet.Unprotect Password:="xxxx"
Me.textbox1.Height = 19.5
Me.textbox1.Width = 160.5
Me.textbox1.Top = 147.75
Me.textbox1.Left = 431.25
ActiveSheet.Protect Password:="xxxx", DrawingObjects:=True, Contents:=True, Scenarios:=True
Application.ScreenUpdating = True
me.textbox1.activate
end sub