Ok, here is the situation. I have an excel document (referred to as "tool")
that is shared between the accounting staff at 40 store locations. Each
store gets it's own unique tool, however, the structure and macros are
identical.

Here is the problem. This tool has 43 sheets in it (kept hidden, unless
being actively used). Some of my users end up losing sheets (liking that of
ripping pages out of a book) as they navigate through the the file.
Something that is not clearly is impossible to do to a shared document. But,
it manages to happen every month.

Observations. On many occasion I have remotely watched the users use the
tool and too many times no fault was incurred. Then one day I found that
some of the users were going back to past copies of the tool. Well we
thought it was the macro not recognizing the difference between months
because it was not written that way. So, on the retooling we placed buttons
to allow the user the opportunity to view past data. We thought that this
may solve the problem. Only no success.
Other Observations. I have been in the tool at the same time that a user
will get into the tool. I will click on a command button then have the user
click on the command button. In that instance between the two clicks pages
have gone missing and I will be removed from the sheet. Much like making the
file exclusive then resharing.

I have set up all the macros to count the sheets in the work book before
proceeding with the action that it is supposed to take. If that step
encounters missing sheets it sends a notification email with user, store, and
macro process. Unfortunately, there is no consistancy in these error alerts.
It occurs with different stores, users and processes.

Has anyone ever experienced this problem before and what would be a
recommended fix?

--
Thanks
Bill