How to make the column in the excel file as read-only?
 

I am handling an excel file as an input. And i want to make the 2nd column in
that file as input only. How do i make it?

How to make the column in the excel file as read-only?
 

What do you mean as input only?
Do you mean that no one can enter a formula into the cell, or paste into it.

You could use an event macro and check that a change was not a formula.

As far as pasting into it -- don't know of any way to test or prevent that.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Manu" wrote in message ...
I am handling an excel file as an input. And i want to make the 2nd column in
that file as input only. How do i make it?

How to make the column in the excel file as read-only?
 

By Input I mean that the column must be automatically loaded by reading any
another cell and must not allow user to alter it after that.


"David McRitchie" wrote:

What do you mean as input only?
Do you mean that no one can enter a formula into the cell, or paste into it.

You could use an event macro and check that a change was not a formula.

As far as pasting into it -- don't know of any way to test or prevent that.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Manu" wrote in message ...
I am handling an excel file as an input. And i want to make the 2nd column in
that file as input only. How do i make it?

How to make the column in the excel file as read-only?
 

Hi Manu,
You might consider using Conditional Formatting to color cells that meet
you conditions for not being changed, and leave it to the user to keep out.

Otherwise, I think you might have to do something like using and Event
macro to unprotect the sheet, protect the cell, then protect the sheet.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Manu" wrote in message ...
By Input I mean that the column must be automatically loaded by reading any
another cell and must not allow user to alter it after that.


"David McRitchie" wrote:

What do you mean as input only?
Do you mean that no one can enter a formula into the cell, or paste into it.

You could use an event macro and check that a change was not a formula.

As far as pasting into it -- don't know of any way to test or prevent that.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Manu" wrote in message ...
I am handling an excel file as an input. And i want to make the 2nd column in
that file as input only. How do i make it?