I have a list of passwords that I want to apply individually to mulitple
worksheets.
The mutiple worksheets in one one workbook is accessed by numerous
individuals.
I have a separate file maintaining the worksheet names (in column "A") and
the corresponding individual passwords to each sheet (in column "B"). My
need is to loop through the listing and set the passwords for each
worksheet. When I add a worksheet or change the password for another
worksheet, I would like to use the listing to reset or add the password to
the corresponding worksheets.
How would I implement this in VBA?
I would appreciate any guidance.
Jack

Jack - I've watch this with interest as I had a similar need some time ago. I
had some sucess with my own efforts which is possibly not totally what you
want. If you email me at I'll share my ideas with you.
--
HJN


"jack" wrote:

I have a list of passwords that I want to apply individually to mulitple
worksheets.
The mutiple worksheets in one one workbook is accessed by numerous
individuals.
I have a separate file maintaining the worksheet names (in column "A") and
the corresponding individual passwords to each sheet (in column "B"). My
need is to loop through the listing and set the passwords for each
worksheet. When I add a worksheet or change the password for another
worksheet, I would like to use the listing to reset or add the password to
the corresponding worksheets.
How would I implement this in VBA?
I would appreciate any guidance.
Jack

Hennie

Why not share your ideas with all of us?

Post your code.


Gord Dibben MS Excel MVP

On Mon, 2 Mar 2009 18:34:01 -0800, Hennie Neuhoff
wrote:

Jack - I've watch this with interest as I had a similar need some time ago. I
had some sucess with my own efforts which is possibly not totally what you
want. If you email me at I'll share my ideas with you.

Gord,
Thanks ... I was about to post the same question to Hennie when I saw your
post.
I share your same thoughts and would greatly appreciate any guidance to
resolve my problem.
Jack


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Hennie

Why not share your ideas with all of us?

Post your code.


Gord Dibben MS Excel MVP

On Mon, 2 Mar 2009 18:34:01 -0800, Hennie Neuhoff
wrote:

Jack - I've watch this with interest as I had a similar need some time ago.
I
had some sucess with my own efforts which is possibly not totally what you
want. If you email me at I'll share my ideas with you.

Any have any thought on how I can accomplish this with VBA?
I'm getting no where with what I've tried.
Any halp would be greatly appreciated.
Jack



"jack" wrote in message
...
I have a list of passwords that I want to apply individually to mulitple
worksheets.
The mutiple worksheets in one one workbook is accessed by numerous
individuals.
I have a separate file maintaining the worksheet names (in column "A") and
the corresponding individual passwords to each sheet (in column "B"). My
need is to loop through the listing and set the passwords for each
worksheet. When I add a worksheet or change the password for another
worksheet, I would like to use the listing to reset or add the password to
the corresponding worksheets.
How would I implement this in VBA?
I would appreciate any guidance.
Jack