protecting multiple shts with separate pwrds
 

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

protecting multiple shts with separate pwrds
 

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

protecting multiple shts with separate pwrds
 

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.

protecting multiple shts with separate pwrds
 

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.

protecting multiple shts with separate pwrds
 

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