"Open" the file?
The further details are that there are a list of inputs that the user must
give, for different choices of what project to run the program (a comparison
of procurement info) on. At first, the system was the brain child of one
person, to be used by one department. As such, it was developed to use
sheets within the file itself, to take the input. Procurement could put in
the info once, and then just pick the sheet that described their run time
choices.
But after the system was mostly done, the Operations department got wind of
it, and the expanded system now does similar things for them.
But, the concern is that since the input is taken from sheets within the
Excel file that is accessible to everybody ("everybody" used to be just one
person), the input data/constraints/item change history is vunlerable to
other people deleting someone else's input info.
So, if the same info that is now on sheets within one file, were in seperate
files controlled by the multple users, they could each have their own input
files, without having it be subject to the deletion of another.
But I'm not sure how an "Open" command button would do what I'm looking for?
At best, it would take you to something else which then asked you, "Which
file is your input file?" Which leads to the multiple user interfaces that I
mentioned before. I can do it, but I was hoping for a better way, within the
"clean-ness" of one user interface.