password form from royuk

**fanta4** · 06-07-2011, 01:47 PM

hi...
is it possible that a user can open more than 1 sheet?
so that

sLevel = cl.Offset(0, 2).Value

goes from (0,2) to (0,6) and opens the sheets which are in this cells...
and is it possible that the current user is written on the splash sheet so i can read it into another sheet to use it as a username in an audit?
ty

**royUK** · 06-07-2011, 02:09 PM

The code can be adapted to do that. I'll have a look tomorrow

**fanta4** · 06-07-2011, 02:17 PM

ty very much roy..

**fanta4** · 06-09-2011, 06:41 AM

any news?
ty

**royUK** · 06-11-2011, 11:33 AM

I've been very busy, but just found time to look at this today.

PASSWORD FORM5.zip

**fanta4** · 06-15-2011, 09:11 AM

ty very much royuk

**xlr8r** · 10-11-2011, 10:01 AM

Originally Posted by royUK

I've been very busy, but just found time to look at this today.

PASSWORD FORM5.zip

Thanks , But how do i embed this into my workbook that has 8 or 9 sheets ?

when i used your file , it locked the whole workbook and only showed that splash sheet ?

i want to just password protect one of my nine sheets ? what modification is needed to your file ? thanks