Environ nightmare

[DThib]

My Inventory workbook has been working well for months. It has a code in the opening that checks for my login ID. It will show a worksheet for me to edit but not anyone else.
2 questions:
1) How do I add 2 more names so they may edit.
2) The other users are now getting the macro slowing to look for the Environ name and then it crashes.
It isn't supposed to and didn't befor last week.

Help!
Code for workbook open below:

Private Sub Workbook_Open()
 Dim UsedRange
  
  Worksheets("Inventory").Activate
  ActiveSheet.UsedRange.Select
  ActiveSheet.UsedRange.Copy
  Range("A2").Select
  Worksheets("Empty Boxes").Activate
  Range("A1").Select
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
  Range("A2").Select
  Application.CutCopyMode = False
  Worksheets("Inventory").Activate
  Range("A1").Select
  Application.CutCopyMode = False
  Worksheets("Start").Activate
  Range("E3").Select
   Worksheets("Inventory").Visible = xlSheetVisible
  
    If Environ("username") = "dthibode" Then
    'testing - show the sheet
     Worksheets("Inventory").Visible = xlSheetVisible
     Else
    'standard user - completely hide sheet
     Worksheets("Inventory").Visible = xlSheetHidden
    End If
End Sub

Any ideas?

 

[DThib]

What's the error?

1 error reported is a Compile Error: "Can't find object or library" highlighting Environ.
and then crashes.

Then when they try to open after getting out, it crashes.

 

[Andrew Poulsom]

Tell your users to activate the Visual Basic Editor, select the workbook in the Project window, choose Tools|References and uncheck any that are marked as MISSING.

 

[DThib]

Thank you sir. That did it!
Never would have thought of that...

Debbie