I have a Macro that uses a VBA form to ask the user to pick from a list. The list is read from a table found in an Excel document that is an asset of the PDM vault. As I developed the macro everything ran fine, but when I distributed it to a co-worker it crashed when accessing the worksheet. Putting in code breaks it looks as if it was crashing here:

' Access the worksheet Set ws = excelWorkbook.Sheets("Vendor