Dependent Drop-Downs (Contextures web site)

P

Pepper

I got some incredible useful information from this website,
http://contextures.com/tiptech.html and have created dependent drop-down
lists.
Note to Debra Dalgleish: Do not end supporting your website. It is
wonderful.

My question is, how can I hide the validation formula for the dependent
list. I am using it as a training (and research) item, wanting my charges to
figure out how to do it as I did, Search the Web.
Thus, I want to create a File for them to see, and then figure out how it is
done.

Thanks you
Pepper
 
B

Barb Reinhardt

You could replace the =OFFSET by another named range and put the offset in
the named range. But they still can look.

Alternatively, you could protect the sheet/workbook, but we all know that
the passwords can be broken so if you have someone who is especially
resourceful in your class, they'll figure it out that way as well.
 
D

Debra Dalgleish

Thanks, I'm glad you like the website, and I hav no plans to end it any
time soon.

Instead of giving people a copy of the worksheet, you could do a demo,
or make a video to show it in action.

Then ask people to research how you did it.
 
P

Pepper

I appreciate the suggestion, I have software to do video, and publish as
either swf or exe. I will give it a try.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top