Quote Originally Posted by tigeravatar View Post
@ukphoenix:
I came up with a non-VBA solution (see attached), though its a bit more comprehensive than what you originally asked for. It is a .xlsx file so it requires excel 2007 or higher to view. Just set the parameters you're looking for and press F9 to generate a new password until it gives you one you want. Then you can copy/paste the password into a notepad or word doc to keep it. If you'd like to see what's going on behind the scenes, the worksheet protection password is "123" (no quotes), and columns A:K are hidden.
Do you have any ideas on how we can take your formula and apply it in a column for more than one at a time?
I envision a column with usernames and then a column for passwords, then using mail merge to send them out.