V
vicky
i want to store Sheet name and its corresponding password in a 2
dimension array . hope anyone can provide a code snippet for storing
sheet name and its corresponding password and also code for popping
out values from an array . i am newbie to vba . providin code wil be
really helpful . i need something like
i need to store the values in this fashion
Array(0) ----- > should contain sheetname and its password value
Array(1) ----- > should contain sheetname and its password value
while popping out i shuld put the values in 2 variables .
sheet name in Variable 1 its corresponding password in
Password in Variable 2 ................
hope anyone can provide a code for this ........
dimension array . hope anyone can provide a code snippet for storing
sheet name and its corresponding password and also code for popping
out values from an array . i am newbie to vba . providin code wil be
really helpful . i need something like
i need to store the values in this fashion
Array(0) ----- > should contain sheetname and its password value
Array(1) ----- > should contain sheetname and its password value
while popping out i shuld put the values in 2 variables .
sheet name in Variable 1 its corresponding password in
Password in Variable 2 ................
hope anyone can provide a code for this ........