OK, I got it to work by editing cells J4-J18 to eliminate the reference to the START folder as
you recommended in one of your posts to:
=cat(F5:I5, "") & IF(F5 = 'these', "s", "")
etc... from J4 to J18.
I then copied the revised EF000000-PasswordGen.xlsm file to the START folder, and the app worked.
Pressing F9 then changed the pass phrases as designed.
However, it will only run if the EF000000-PasswordGen.xlsm file is in the START folder. I don't want this
file to run every time I start Excel so I tried updating the internal link referring to Personal.xls in
the original file, but Excel will not let me change this.
Thanks for your help with this. I'll try to get this to work in folders other than START, but will
have to read up on updating links in Excel which apparently is not my strong point.
Bookmarks