VB CODE
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 |
VB CODE
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 |
VB CODE
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 |
VB CODE
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 |
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com