Random password generator help

If there is a thread that already exists for this, I'm having a hard time finding it.

Looking for a quick, easy function that I can use to generate a randomized 12 character password out of upper and lower case letters, 0-9 numbers and special characters.

I have a website I have to login to for work and the password needs to be changed often so looking for something I can just click a button or something and then copy and paste the password to reset it. It won't let you use anything you've used in the past 5 years and it can't contain any "sequential" letters that spell out a word.

I thought this might be easier than keeping track of all the passwords I've used in the past 5 years and going through the list every time to make sure the new one doesn't match any of the old ones.

Thanks in advance!

Damn, that was fast!

Thanks so much!

why not use a password manager? fwiw I use Enpass. Passphrases are great, but you still have to remember them, and most sites will not accept them.

Hello. I'm a new member. I saw your post and attachment (72.0 KB file) for creating a passphrase. It is a nice app.

I know this is an old post, but I thought I would try for a reply from you.

Since I don't use a Personal.xls file in XLSTART I was wondering if there was a way to get the 'cat' function in your passphrase Module1 to work without this file. It seems like the generated phrase in col J depends on info in the personal.xls file. If I can create another .xls file and place it in the same folder as the .xlsm file with the needed info then that will probably work. Thanks.

I tried that and the cells J4-J18 in the .xlsm file indicate an error '#NAME?'.

I tried entering the word 'these' in cell F4 in the .xlsm file and Excel still indicates '#NAME?' in J4.

Is there some other data that the .xlsm file is dependent on and that contains the 'Possessives'
such as these, our etc...?

If so can you show an example of the format of this data as it may appear in the Personal.xls file.

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.

That did the trick. After breaking the link I copied the formula:

=Module1.Cat(F4:I4, "") & IF(F4 = "these", "s", "")

I added the IF to take care of the possessive in F4.

I saved the file and Excel displayed a message box indicating that:

"You have modified a signed project. You do not have the correct key to sign the project..."

It allowed me to cancel or save it. I saved it.

It now runs from any folder.

I've been looking for a pass phrase project, and this is a nice app. Thanks for providing it & your help.

Btw, I have some experience with coding in Excel and Access, mostly from work related projects when I
was employed. I'm now retired, and a bit rusty, however, as it has been several years, but I still like
to dabble in it once in a while.