Try: Alloweditranges.add method
or tools-protection-allow ranges for users (A:A)

"Tom LeBold" wrote:

In Microsoft Access I have locked or disabled controls or columns to prevent
the user from changing the data displayed in the column.
Is it possible to lock, protect or disable a column in Excel?
I don't want the user to be able to enter data in column A.