@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.
Bookmarks