Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My problem is I have some value in the first row
suppose A1 has value NAME B1 has value ADDRESS C1 has value PHONE I want to write a VB code which tells .. If i try to change the value in these cells then there should be a message telling " these cells are non editable" the the old values like NAME should be retained in that cell PLz help me |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Why not protect the sheet with these 3 cells locked.
First select all cells and unlock them (CellsProtection and uncheck the Locked box) Select A1:C1, and lock them Then protect the sheet (ToolsProtectWorksheet) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gull" wrote in message oups.com... My problem is I have some value in the first row suppose A1 has value NAME B1 has value ADDRESS C1 has value PHONE I want to write a VB code which tells .. If i try to change the value in these cells then there should be a message telling " these cells are non editable" the the old values like NAME should be retained in that cell PLz help me |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Why don't you protect those cells.
This is one option of how you can do it: To unlock all cells, select all cells in the worksheet and FORMAT CELLS - PROTECTION - Uncheck LOCKED. Then select the cells that you want protected and FORMAT -CELLS- PROTECTION - Check LOCKED Then TOOLS - PROTECTION I'd uncheck SELECT LOCKED CELLS. If there are other things that your users need to be able to do, make sure you allow it on this sheet. "Gull" wrote in message oups.com... My problem is I have some value in the first row suppose A1 has value NAME B1 has value ADDRESS C1 has value PHONE I want to write a VB code which tells .. If i try to change the value in these cells then there should be a message telling " these cells are non editable" the the old values like NAME should be retained in that cell PLz help me |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have asimilar problem,
I don't want user to be able to change the cell - but they can be allowed to delete the row... UI sm using Excel 2000 -- is this possible? wAyne_ "Barb Reinhardt" wrote: Why don't you protect those cells. This is one option of how you can do it: To unlock all cells, select all cells in the worksheet and FORMAT CELLS - PROTECTION - Uncheck LOCKED. Then select the cells that you want protected and FORMAT -CELLS- PROTECTION - Check LOCKED Then TOOLS - PROTECTION I'd uncheck SELECT LOCKED CELLS. If there are other things that your users need to be able to do, make sure you allow it on this sheet. "Gull" wrote in message oups.com... My problem is I have some value in the first row suppose A1 has value NAME B1 has value ADDRESS C1 has value PHONE I want to write a VB code which tells .. If i try to change the value in these cells then there should be a message telling " these cells are non editable" the the old values like NAME should be retained in that cell PLz help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change case...help please | Excel Worksheet Functions | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Using other workbooks.. | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) |