Protecting a sheet on startup

[Daniel Cremin]

Hi i need code for my auto_open macro that
can make two worksheets ("Control and Reference
Sheet") and "Processing and Storage" protected
with only unlocked cells being allowed to be
selected. The thing is is that i dont want the
user to see these sheets at all - it should
automatically go to a "main menu sheet" with
the sheet tabs, rows and columns ,etc hidden.
is this possible?

Thanks very very much in advance.

Another macro needs to be ab

 

[Daniel Cremin]

im not allowed to use code as advanced as that at this level - its a school project marked by really dense examiners who hate ne thing above activecell.offset !

Could i use a select... case statement and make
it equal to a named cell rather than text?

So Select Range("PasswordEntry")

Case Is = Sheets("C/R").Range("Password")
run code

case else

reset the contents of "Password entry"

End sub

 

[Daniel Cremin]

hi again

the select case works but doesnt allow for the
password to be a number.

 

[Legacy 98055]

Will this work?
Case Is = Sheets("C/R").Range("Password").Value

or

Case Is = str$(Sheets("C/R").Range("Password"))

Tom

 

[Daniel Cremin]

well i tried the first myself and it didnt, but
ill have a go with the second thanks.