Hi,
I have a workbook that has 22 tabs and I want to have a different password for each tab. I know it's possible to do with a VB code, but I know nothing about VB. I'm wondering if someone could help me out?
Thanks in advance for your help.
Hi,
I have a workbook that has 22 tabs and I want to have a different password for each tab. I know it's possible to do with a VB code, but I know nothing about VB. I'm wondering if someone could help me out?
Thanks in advance for your help.
You do not indicate how the passwords are determined.
If you have 22 sheets, the following macro assign the letters A through V (all passwords would be uppercase letters.
Please Login or Register to view this content.
This one removes the passwords.
Please Login or Register to view this content.
thankyou, where do i insert this? the passwords are defined by myself, each is six chrs in length
Last edited by Socrates; 10-25-2009 at 11:38 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks