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

Manu · 04-22-2005, 11:06 AM

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?

**justchris** · 04-22-2005, 11:47 AM

highlight the column you wish to lock
In the tools menu click
<--format cells
click the protections tab
select locked
Then, you will need to lock or "protect" the sheet, click the tools menu <---protection <--- protect worksheet

Note: protecting the sheet protects all cells, as default all cells are locked (at least i'm pretty sure ) so you will need to unprotect all cells that you will be using as input cells. to do that follow the same procedure as above but instead of selecting lock, unselect it. Hope that helps

David McRitchie · 04-24-2005, 01:06 AM

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" <[email protected]> wrote in message news:[email protected]...
> 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?

Manu · 04-24-2005, 05:06 AM

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" <[email protected]> wrote in message news:[email protected]...
> > 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?
>
>
>

David McRitchie · 04-24-2005, 11:06 PM

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" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
> > > 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?
> >
> >
> >

**selami güzel** · 04-26-2005, 05:40 PM

Originally Posted by Manu

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?

Hi ;

click "format cells"/cells/protect/locked,

select the cells that you want to make them only entering data,

click tools/protection/permission for users ( second line), then click "new"/"OK" on the dialog box/OK/OK

click Tools/Protection/Protect worksheet/ Write your secret code and click "OK" then rewrite your same secret code new dialog box then "OK"

NOT: pls. do not forget your secret code that you wrote.

sencerely

Selami Güzel

[email protected]