I have a spreadsheet where users will enter account numbers in 10 specific
rows in a specific column. They will only be able to enter certain accounts.
The accounts will be located on a hidden worksheet so the users won't see
them.

I could create a data validation for those rows on that column when the
workbook is opened but I was wondering if there is a better way. I will
probably want to create a drop down list that they can access or perhaps add
the acccounts in a comment for each of the 10 rows.

Is there another way to do this? Any suggestions or code to accomplish this
would be appreciated. Thanks......
--
JT

Data validation sounds like the best way. Why is that a problem?

--
Regards,
Tom Ogilvy



"JT" wrote:

I have a spreadsheet where users will enter account numbers in 10 specific
rows in a specific column. They will only be able to enter certain accounts.
The accounts will be located on a hidden worksheet so the users won't see
them.

I could create a data validation for those rows on that column when the
workbook is opened but I was wondering if there is a better way. I will
probably want to create a drop down list that they can access or perhaps add
the acccounts in a comment for each of the 10 rows.

Is there another way to do this? Any suggestions or code to accomplish this
would be appreciated. Thanks......
--
JT