The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed.
HOW TO ATTACH YOUR SAMPLE WORKBOOK:Unregistered, Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

Search:

Tag: locking cells

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Unlocked Cells in Table based if date criteria met

Started by JyothiGrace‎, 02-11-2022 02:17 PM
- 3
- 454
Last Post By:

Last Post: 02-23-2022 05:01 PM

by Mumps1

Forum:
Excel Programming / VBA / Macros
[SOLVED] VBA locking and unlocking cells in protected sheet

Started by StartingWithExcel‎, 11-24-2020 05:27 PM
- 3
- 553
Last Post By:

Last Post: 11-25-2020 10:26 AM

by 6StringJazzer

Forum:
Excel Programming / VBA / Macros
Lock Table But Allow Sorting

Started by SKKS‎, 07-15-2019 04:26 PM
- 5
- 2,143
Last Post By:

Last Post: 07-15-2019 04:52 PM

by SKKS

Forum:
Excel General
How to auto number each row and have it locked to that row

Started by jhkgbs‎, 12-20-2018 12:15 PM
- 3
- 911
Last Post By:

Last Post: 12-20-2018 01:10 PM

by dosydos

Forum:
Excel Formulas & Functions
Locking different values within cell depending if they are dragged vertically or horizonta

Started by Sonogan‎, 06-30-2016 09:48 AM
- 20
- 1,218
Last Post By:

Last Post: 07-01-2016 07:31 AM

by Sonogan

Forum:
Excel Formulas & Functions
Use and auto-sort names from a master list, with multiple columns under every name

Started by mojohnsen89‎, 06-30-2015 03:37 PM
- 2
- 851
Last Post By:

Last Post: 06-30-2015 04:45 PM

by oeldere

Forum:
Excel Formulas & Functions
Sorting cells in one column with dependent information in other columns

Started by shntenchi‎, 06-28-2015 03:36 AM
- 8
- 4,170
Last Post By:

Last Post: 06-28-2015 02:32 PM

by popipipo

Forum:
Excel General
Lock cell on conditional data

Started by joodkap‎, 07-09-2014 01:55 PM
- 3
- 651
Last Post By:

Last Post: 07-10-2014 09:16 AM

by joodkap

Forum:
Excel Formulas & Functions
[SOLVED] Locking cells based on color in doc with merged cells

Started by mushedpotatos‎, 07-02-2014 10:32 AM
- 2
- 763
Last Post By:

Last Post: 07-03-2014 03:14 AM

by mushedpotatos

Forum:
Excel Programming / VBA / Macros
[SOLVED] Locking cells except through Export through Userform

Started by aaron.mendes‎, 10-31-2013 08:51 AM
- 3
- 752
Last Post By:

Last Post: 11-04-2013 09:53 AM

by jaslake

Forum:
Excel Programming / VBA / Macros
[SOLVED] How to lock a cell without protecting the worksheet

Started by jimbo213mo‎, 08-30-2013 04:20 PM
- 5
- 1,280
Last Post By:

Last Post: 08-30-2013 06:03 PM

by Kalithro

Forum:
Excel Programming / VBA / Macros
Locking cells until conditional formatting rules return false

Started by emilyloz‎, 06-12-2013 08:32 AM
- 1
- 722
Last Post By:

Last Post: 06-12-2013 10:23 AM

by emilyloz

Forum:
Excel General
[SOLVED] Desperate Help needed with Locking out a range of cells based on selection from 1 cell

Started by Vcummi‎, 05-31-2012 12:36 PM
- 7
- 959
Last Post By:

Last Post: 05-31-2012 04:12 PM

by Vcummi

Forum:
Excel Programming / VBA / Macros
Inventory; how to reset input variable without changing the output cell's value

Started by ThunkLogic‎, 03-10-2011 01:28 AM
- 1
- 1,561
Last Post By:

Last Post: 03-14-2011 11:37 AM

by ThunkLogic

Forum:
Excel Formulas & Functions
check box to lock cells, date stamp and hide itself after checking

Started by niks‎, 11-16-2010 08:21 AM
- 11
- 3,711
Last Post By:

Last Post: 11-16-2010 10:17 AM

by niks

Forum:
Excel Programming / VBA / Macros

Results 1 to 15 of 15

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Unlocked Cells in Table based if date criteria met

[SOLVED] VBA locking and unlocking cells in protected sheet

[SOLVED] Locking cells based on color in doc with merged cells

[SOLVED] Locking cells except through Export through Userform

[SOLVED] How to lock a cell without protecting the worksheet

[SOLVED] Desperate Help needed with Locking out a range of cells based on selection from 1 cell