Password Protection solution 2

[MarkBeck]

Hi

I have a workbook that has several users, all of whom have their own input sheet. I need to restrict them to be able to only view their own sheet.

I have a Users table, defining UserName, Password, WorksheetName.

The Welcome sheet asks for input of username & pasword, and returns (index+match formula) in cell "B6" the name of the users sheet, or "Error!" if the UserName & Password combination is wrong.

I would like to create 2 macros;

Macro A) renders ALL SHEETS EXCEPT "Welcome sheet" invisible upon Open (Event based)

Macro B) Makes visible the sheet that is named in "B6" above.

Thanks

Mark

 

[MarkBeck]

Thanks Skip, my slip, you are right about that.

I thank you for your patience. It all works perfect!

Mark

 

[SkipVought]

FYI,

When performing methods on objects, in most cases they should NOT be selected -- just referenced. Selecting SLOWS down the process and forces you to make recovery statements.

Skip,
[sub]
[red][/red]
[/sub]

 

[MarkBeck]

I Thank you Skip. Your advise/ Code is always valuable, to the point and neat.

I would like you to know that before deranging people on this site I first make a conscious effort myself. I am getting much better too.

 

[SkipVought]

Mark,

I am still learning myself. I credit Tek-Tips for a major portion of my gain of skills and knowledge.

Keep in mind that you will get better responses when you are clear, concise and complete when describing your problem and asking for help.

Skip,
[sub]
[red][/red]
[/sub]