|
|||||||
| Applications Use this board for problem solving and the discussion of computer software applications |
 |
|
|
Topic Tools |
|
#1
June 14th, 2010, 05:53 PM
|
|||
|
|||
|
Excel 2007 - Unlocking cells in one column based on values in another column
I have a sheet of data that needs to be locked as it is a template to be used in my business. There are two types of labour - in house for which there are prescribed rates and 3rd party. If in column F third party is selected then I need the corresponding cell in column N to be unlocked. Otherwise it needs to stay locked.
I am struggling to write the VBA (as I have no real knowledge) to make this happen. Any help gratefully received. The data is stored in cell 3-102 in rows F (the defining data as to if the cell should be locked or unlocked) and N (the dependent data to be locked or unlocked) 
|
|
| Bookmarks |
«
Previous Topic
|
Next Topic
»
| Topic Tools | |
|
|
Similar Topics
|
||||
| Topic | Topic Starter | Forum | Replies | Last Post |
| Sum of column between two dates in Excel | danlee58 | Applications | 5 | September 15th, 2020 03:02 PM |
| Microsoft Excel 2007 highlights multiple cells | biz_kid1 | Applications | 0 | August 12th, 2008 08:03 PM |
| Hide/Show column and row headings in Excel? | deronsizemore | Applications | 1 | September 16th, 2006 06:23 AM |
| Excel Column Border Missing | Delphi123 | Applications | 4 | October 17th, 2003 11:21 PM |
All times are GMT +1. The time now is 06:33 PM.