Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking cells using VBA based on other cell values
Hi,
I'm trying to lock cells in a column on an excel spreadsheet depending on the (date) value in another cell on the same row. For example, I'm thinking of it like this: If range("C9").value today() Then range("G9").lock = false Else range("G9").lock = true End if However I want to do it for all rows between 9 and 400 whenever the sheet is accessed. Can anyone help? Many thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking cells using VBA based on other cell values
1) Cells are automatically locked by default, but you have to protect the
workbook to make the locking work. 2) You start off with all cells locked and the worksheet unprotected. To answer your question theSheet.unprotect Range("9:400").locked = true theSheet.protect "Evil Red Smurf" wrote: Hi, I'm trying to lock cells in a column on an excel spreadsheet depending on the (date) value in another cell on the same row. For example, I'm thinking of it like this: If range("C9").value today() Then range("G9").lock = false Else range("G9").lock = true End if However I want to do it for all rows between 9 and 400 whenever the sheet is accessed. Can anyone help? Many thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking cells using VBA based on other cell values
You have a response in VBAExpress.!
-- __________________________________ HTH Bob "Evil Red Smurf" <Evil Red wrote in message ... Hi, I'm trying to lock cells in a column on an excel spreadsheet depending on the (date) value in another cell on the same row. For example, I'm thinking of it like this: If range("C9").value today() Then range("G9").lock = false Else range("G9").lock = true End if However I want to do it for all rows between 9 and 400 whenever the sheet is accessed. Can anyone help? Many thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking cells using VBA based on other cell values
Sorry I don't think I explained myself clearly previously.
I have a spreadsheet which is ready for data to be entered into G9:G400. I have protected the spreadsheet with a password and unlocked G9:G400. What I would like to do is if a date value in each of the cells in c9:C400 is greater than today's date then the corresponding cell in column G should remain unlocked and users be able to enter data into it. However if the date value in C9:C400 is equal to or prior to todays date then the correponding cell in column G should be locked. Apologies again for not explaining that more clearly previously, if you could help I would be most grateful. "incre-d" wrote: 1) Cells are automatically locked by default, but you have to protect the workbook to make the locking work. 2) You start off with all cells locked and the worksheet unprotected. To answer your question theSheet.unprotect Range("9:400").locked = true theSheet.protect "Evil Red Smurf" wrote: Hi, I'm trying to lock cells in a column on an excel spreadsheet depending on the (date) value in another cell on the same row. For example, I'm thinking of it like this: If range("C9").value today() Then range("G9").lock = false Else range("G9").lock = true End if However I want to do it for all rows between 9 and 400 whenever the sheet is accessed. Can anyone help? Many thanks, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking cells using VBA based on other cell values
Hi,
I need something very similar. I need to interagate cells D8 through D69 and if there is an X in one of those cells then I need to unlock the cell in column E so if D8 has an X then I need to unlock E8, if D9 has an X then I need to unlock E9 etc. I am not sure how to find the response you noted below. I am working very trial and error at adding bits of VBA code to my spreadsheets to make them more user friendly. Thank you for your help. "Bob Phillips" wrote: You have a response in VBAExpress.! -- __________________________________ HTH Bob "Evil Red Smurf" <Evil Red wrote in message ... Hi, I'm trying to lock cells in a column on an excel spreadsheet depending on the (date) value in another cell on the same row. For example, I'm thinking of it like this: If range("C9").value today() Then range("G9").lock = false Else range("G9").lock = true End if However I want to do it for all rows between 9 and 400 whenever the sheet is accessed. Can anyone help? Many thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking a cell based on a cells content | Excel Discussion (Misc queries) | |||
Excel Locking cells based on value in another cell | Excel Discussion (Misc queries) | |||
locking cells based on results at runtime | Excel Worksheet Functions | |||
locking cells based on condition | Excel Programming | |||
Locking other cells based on values in a cell. | Excel Programming |