You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Conditional Cell Lock

Conditional Cell Lock

Price: FREE

I am just having problems with people editing the cell values. I know how to lock particular cells in a worksheet but how do I achieve
conditional cell lock?
i.e People put inputs in column A and normally Column G:H are locked for editing. However if input in column A is "ABC" I want to let them edit or put inputs in Column G:H for that row.
e.g. If A10 = "ABC" then Unlock G10 & H10 and if cell value is other than "ABC" then lock.

Visit publisher's web-site: Conditional Cell Lock

Category and Tags: ExcelTutorials :

Related Tutorials

Lock cell formats (conditional format)

Free: Yes
Tags: Excel › Functions

Is it possible to lock a cells format so that you can only ever paste values

lock cell conditional format but not restrict data entry

Free: Yes
Tags: Excel › Functions

A problem with user inputs is that they often copy-paste dates. I'd like them to either type in a date or use paste-special-value. With multiple users this is virtually impossible to control.
Is there a way to lock cell conditional formats but not restrict data entry?

Conditional Formatting to Lock Cells

Free: Yes
Tags: Excel › Functions

Is there a way to lock the adjacent cells in a row, if "contractor" is entered into the cell?

Conditional Cell Protection In Excel 2003

Free: Yes
Tags: Excel › VBA

I'm putting together a spreadsheet using a few VBA macros that requires input into a column of cells by users. However I want to restrict entry into the cells if a different column of cells contains a date in the future. I understand this may sound confusing, so here is an example:
If A1 > today() then lock D1
If A2 > today() then lock D2
If A3 > today() then lock D3
If A4 > today() then lock D4
etc.
But I want it for approximately 400 lines.

Conditional Proctection?

Free: Yes
Tags: Excel › Functions

Is it possible to lock/unlock cells based on another cell value?
If cell = "text1" unlock cells A4:B4 and lock cells C44 If cell = "text2" unlock cells C44 and lock cells A4:B4
The text1, text2 are from a combo box drop down list located on another

Related Applications & Scripts

EXE Vault: Lock and Unlock Applications

Free: No
Tags: Software › Excel Security

Instantly Lock And Unlock EXE Program Files The EXE Vault is a handy software program that lets you 'lock' exe files (including setup files) so they can't be opened. The Vault is very easy to use. Simply open the file, click the option and hit 'Do It'. Last 5 actions are shown in a easy to follow list at the bottom. Simple yet very efficient.

Viral Lock PHP - Facebook Like, Google+1 or Tweet to Unlock

Free: No

Make your site go viral by requiring your users to Facebook Like, Google+1 or Tweet about your page to reveal premium content. Simply wrap the content you want to protect with the script and your content will be protected until the users shares your page. Viral-Lock is the first of its kind to combine Facebook, Google+ and Twitter to give maximal viral impact. More likes and tweets = More money for you.
Based on our Viral Lock plugin for WordPress the PHP version enables you to integrate the power of Viral Lock into anything. Anything you can put in a PHP file can be protected!

My ASP Page Lock

Free: No
Tags: ASP › Excel User Authentication

My ASP Page Lock is the easiest, fastest and cheapest way to restrict access to any page in your site.
Completely idiot proof, you should have no trouble installing and using it within a matter of minutes.
M.A.P.L is written in ASP/VBscript using Macromedia Ultradev, it is 100% customisable and extendible. Easy straight forward setup just one line of code per page! Even a complete novice can use it.
Just upload 'My ASP Page Lock' onto your webserver and you're ready to go! No ASP knowledge is required.

Swf Lock It!

Free: No
Tags: Flash › Excel Miscellaneous

This a simple way to protect your files. Simple, but very useful. For example: You did a job for your client...he got the files and everything is right, except the fact that he doesn't pay you. With this file, you can make your files expire in any date.
So, if your client doesn't pay you, in some days he could get a nice surprise! You can customize everything. This is a simple file and all instructions are included.

Instant Messaging, Websites and Programs Blocker

Free: No
Tags: Software › Excel Security

Instant Message Blocking
Internet Filter
Web Filtering
Live Updates
Scheduler
Web Browsing Control Features
Windows Lockdown Features
Ad Hoc Web Blocking
Ad Hoc Program Blocking
Password Protected Control Panel

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing