Does this require programming? If so, how? :)

[Nornny]

*I apologize that this is cross-posted. I realizee I might've put m
post in the wrong newsgroup*

This isn't so much a workbook security question as it is just a basi
programming question. I'm a total newbie on this and only have C++ an
HTML experience, but I understand how macros work also (it's prett
basic, but I have used them). VBA doesn't seem entirely difficult t
learn, but I could use some guidance.

I have two worksheets, one with a list of sites. Each site is assigne
a password through a very simple proccess. Each site is actually a 1-
digit number. I split the digits up, and multiply each digit by a see
number of 4-7 (depending on how many digits the site has), and the
concatenate that with standard text. Here's an example.

Site 766

Value-----------Seed-------------Key-------------PW
7-----------------6-----------------42-------------dog42
6-----------------5-----------------30------------dog30
6-----------------4-----------------24-------------dog24

A 4-digit password would have its first digit start with 7 as a seed.

So I got that working. I created a worksheet in which you enter in
site number, and it pops out a password. Easy enough with simpl
functions.

NOW, I have a separate database of site numbers. I've also include
their respective passwords. One digit sites have only 1 password, but
digit sites have 4. Each site begins with their first password (dog4
in the ex) as their current password. But, when the user wants to
he/she just enters in their site number in that form I mentione
earlier, and it should pop out the next password. If it only has on
pw, it will output the same one. If it's on its last pw, it will outpu
its first again.

In my database sheet, I added a column for the current pw, and a colum
for the next pw. The problem I have is updating them once a user enter
a site number. Can this be done with macros? Thanks in advance for an
help

 

[jeff]

Hi, Nornny,

Yes it can be done with a simple macro - your biggest
concern is where you'll put the passwords for protection-
you'll have to hide then on a sheet and protect it.
But basically, you can simply assign the current password
and new password at the end of your pw generating macro
to specific cells.

jeff

 

[Nornny]

Hi Jeff. I do intend to hide or protect that database worksheet, which
looks something like this:

No--Value--Seed--Key--PW1--PW2--PW3--PW4--Curr--Next
1234 1 7 7 d7 d12 d15 d16 d7 d12
etc...



I hope that shows up okay. There are actually 4 columns each of Value,
Seed, and Key, just like the PW columns, but I'm just saving space.
Curr is the current password, Next is the next password in line.

Are those neccessary if I use a macro? Do I just need current?

And how do i create this macro? I'm trying to learn VBA as I write
this, but if you can provide me with a quick solution, it'd be
EXTREMELY appreciated.

Remember that worksheet2 has three things, a cell to enter the site
number, a cell that will reveal the current password, and a cell that
will reveal the new password (the next password in Sheet1). I just
don't know how to update Worksheet1 now once it has showed a new
password. Any more help? Please??