I have an excel file with a number of modules and workbook codes built to limit access and provide differing functionality. The workbook is made up of about 30 sheets that different people input data in. When the file is placed on a share drive it deletes sheets at odd times and sometimes deletes itself according to the users.

Are there different programming commands to make an excel VB file work on a share drive?