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.
For the best help attach a sample workbook to your post
Attention - ExcelForum Rules have been updated as of August 2023. These rules apply to everyone for the benefit of all, please take a moment now to read them so you will have no issues in complying with them. Please read them here .
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: locked cells

Search: Replies Views Search took 0.00 seconds.

Can't copy and past in protected sheet but can type in cells

Started by lexipants33‎, 08-17-2020 08:42 AM
- 5
- 2,195
Last Post By:

Last Post: 08-17-2020 03:04 PM

by vba_php

Forum:
Excel General
VBA to lock cells on unprotected sheet

Started by Guyel1‎, 05-05-2020 07:10 PM
- 3
- 637
Last Post By:

Last Post: 05-07-2020 07:51 PM

by mgs73

Forum:
Excel Programming / VBA / Macros
Pasting Protected cells

Started by raymondcg‎, 12-04-2019 01:59 PM
- 1
- 478
Last Post By:

Last Post: 12-04-2019 10:29 PM

by saravnepali

Forum:
Excel Formulas & Functions
[SOLVED] cant insert row on locked sheet

Started by jitterbug888‎, 06-13-2019 04:24 AM
- 2
- 514
Last Post By:

Last Post: 06-13-2019 06:45 AM

by jitterbug888

Forum:
Excel Formulas & Functions
Lock cells after filtering

Started by johannordgren‎, 02-22-2019 10:20 AM
- 2
- 489
Last Post By:

Last Post: 02-25-2019 02:33 AM

by johannordgren

Forum:
Excel Formulas & Functions
[SOLVED] Cells editable even though locked & protected? User-editable ranges

Started by IGNF‎, 11-07-2018 12:17 PM
- 10
- 7,658
Last Post By:

Last Post: 12-10-2018 05:38 AM

by IGNF

Forum:
Excel General
[SOLVED] Excel Dropdown Blank [User Can't Click Cells with Dropdown]

Started by jamie.harris‎, 06-19-2018 02:39 PM
- 19
- 14,917
Last Post By:

Last Post: 06-21-2018 04:27 PM

by jamie.harris

Forum:
Excel General
[SOLVED] Enable a hyperlink in a protected cell - excel 2013

Started by vhache‎, 03-23-2016 10:41 AM
- 10
- 23,647
Last Post By:

Last Post: 03-01-2021 04:46 PM

by AliGW

Forum:
Excel General
[SOLVED] help with locking/unlocking cells based on criteria

Started by Dan_api‎, 06-18-2015 10:19 PM
- 3
- 760
Last Post By:

Last Post: 06-22-2015 12:40 PM

by sktneer

Forum:
Excel Programming / VBA / Macros
Locking a range of cells based on the selection from a drop down menu in a different cell?

Started by Mappo‎, 05-27-2015 06:06 AM
- 0
- 559
Last Post By:

Last Post: 05-27-2015 06:06 AM

by Mappo

Forum:
Excel Programming / VBA / Macros
[SOLVED] Deleting info in locked cells/columns

Started by txnc‎, 01-06-2014 11:07 AM
- 18
- 1,906
Last Post By:

Last Post: 01-07-2014 10:06 AM

by TMS

Forum:
Excel General
Detect RightClick on Locked cell

Started by DJvdW‎, 10-30-2013 05:11 AM
- 2
- 1,095
Last Post By:

Last Post: 10-30-2013 06:15 AM

by ragulduy

Forum:
Excel Programming / VBA / Macros
[SOLVED] Unlocked cells not available when sheet is protected.

Started by mowens74‎, 10-15-2013 02:39 AM
- 4
- 1,365
Last Post By:

Last Post: 10-15-2013 05:09 AM

by OllieB

Forum:
Excel Programming / VBA / Macros
Unlock only a range of cells on a locked sheet?

Started by Margate‎, 03-25-2013 09:00 PM
- 3
- 1,315
Last Post By:

Last Post: 03-26-2013 09:32 AM

by Richard Buttrey

Forum:
Excel Programming / VBA / Macros
Drop Menu with VLookup on Locked Cells solution!?

Started by Margate‎, 02-20-2013 05:01 PM
- 2
- 701
Last Post By:

Last Post: 02-20-2013 07:58 PM

by Margate

Forum:
Excel Programming / VBA / Macros
List Data Validation and Protected Worksheet - Cant copy

Started by liam_bettinson‎, 09-06-2012 04:40 AM
- 1
- 1,403
Last Post By:

Last Post: 09-06-2012 06:48 AM

by liam_bettinson

Forum:
Excel Formulas & Functions
Excel template -- allow refresh data but maintain worksheet protection/locked cells

Started by leiaduva‎, 08-30-2012 09:53 AM
- 0
- 1,616
Last Post By:

Last Post: 08-30-2012 09:53 AM

by leiaduva

Forum:
Excel Programming / VBA / Macros
% format overriding cell format

Started by BrianBCrawford‎, 06-13-2012 08:12 PM
- 2
- 720
Last Post By:

Last Post: 06-14-2012 10:42 AM

by BrianBCrawford

Forum:
Excel Programming / VBA / Macros
Autofill Formula Across Locked Cells

Started by WJordan‎, 05-21-2012 09:46 PM
- 4
- 3,856
Last Post By:

Last Post: 05-22-2012 09:59 PM

by WJordan

Forum:
Excel General
Locking out cells based on a toggle selection

Started by concretelackey‎, 02-26-2012 10:57 AM
- 0
- 812
Last Post By:

Last Post: 02-26-2012 10:57 AM

by concretelackey

Forum:
Excel Programming / VBA / Macros

Results 1 to 20 of 20

Search: Replies Views Search took 0.00 seconds.

[SOLVED] cant insert row on locked sheet

[SOLVED] Cells editable even though locked & protected? User-editable ranges

[SOLVED] Excel Dropdown Blank [User Can't Click Cells with Dropdown]

[SOLVED] Enable a hyperlink in a protected cell - excel 2013

[SOLVED] help with locking/unlocking cells based on criteria

[SOLVED] Deleting info in locked cells/columns

[SOLVED] Unlocked cells not available when sheet is protected.