Hi,
Simple question I know and years ago when I learned it at school I remembered but I cant for the life of my remember how!
When using data validation lists, how do you hide and protect the data you are reading from for the dropdown?
Thanking you in advance
What do you mean by:
hide and protect the data you are reading from for the dropdown
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
when reading from a list for data validation i don't want the data in the list to be seen or to be edited.
hide the column
protect the sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks