I have a master file that requires data feeds from multiple users. The way
it works is as follows: the user maintains their data in a separate Excel
file, then clicks a button to UPLOAD their data into the master file (which
basically opens the master file, then copies/pastes the data in). I want to
password protect the master file so no one else can make changes with the
exception of this uploaded data. How do I update my VB code to "enter" the
file password when opening the master file during this upload process, while
ensuring the user does not see or know the password?