I have developed a personal tracking spreadsheet that I
occasionally send out an up-dated version to those using
it. The spreadsheet will automatically up-date the data
into the new version and save it under the same name. The
user simply clicks a data transfer button and is given the
opportunity to open the existing spreadsheet and transfer
the data to the new version. The problem is that I don't
know how to capture the password to include that in the
new up-dated spreadsheet so that the user doesn't have to
re-enter the password during the first save after the up-
date. Is it possible to capture the password of the
opened spreadsheet and save the new version with the same
password? Any help would be appreciated. Thanks!