need to hyperlink to a different tab and prompt for password

[moley165]

hello all,

dont know if this is possible but need to have it so that i have a front page with 2 options both hyperlinks and one of them is only accessable if you answer a password. any ideas people ?

thanks


ricky

[Jester0001]

Do you want the user to not see the sheet at all unless they get the password correct? Or do you just not want them to enter/edit data on the sheet without the password? The answer to these questions will depend upon the approach we will take.

[moley165]

i dont want them to see the next sheet if they dont answer the pass word correctly


thank you

ricky

[moley165]

any ideas guys??

[moley165]

hi the password is twmanagement

[john456852]

do u no how to make activecell in sheet2?

[john456852]

i protected sheet2
so click on review, unprotect sheet and enter ps