I have a Marco that runs a series of VLookups from a button in the excel
sheet. The Macro is stored in the personal worksheet which is always hidden.
The workbook is used as a template that is stored on the server where it is
access by multiple users. My problem is that some how the macro is €œlosing€�
the path to the €œtable array€� sheet that is stored in a separate worksheet on
the server. When you hit the button for the Vlookup; a window for u to
navigate to the file that contains the sheet for the €œtable array€� values
appears. This is very frustrating and perplexing to me. If anyone has any
ides as to how I can solve this issue I would be very grateful.