| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make read-only file | Excel Discussion (Misc queries) | |||
| How do I make an Excel 2007 file read-only? | Excel Discussion (Misc queries) | |||
| Make excel open file without Read Only dialog | Excel Discussion (Misc queries) | |||
| How do I make a file read only unless a password is supplied? | Excel Discussion (Misc queries) | |||
| Make a file read only | Excel Programming | |||
Linear Mode
