Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock Cells in excel 2007

Status
Not open for further replies.
wmbb

wmbb

Technical User
Jul 17, 2005
320
NL
In addition to my previous post...

Is it possible to lock cells with conditional formatting using the formula option ?
 
Sort by date Sort by votes



Cell locking is not a CF option.

In order to have cell locking, 1) the cell must be locked and 2) the sheet must be protected.

If the sheet is protected, then the locking cannot be changed. The sheet must FIRST be unprotected.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Upvote 0 Downvote
If I understand what you write, this must be solved using VB.
I will ask this question in that forum.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
414
N1GHTEYES
N1GHTEYES
Swi
  • Question
Excel Webservice
Replies
2
Views
339
mintjulep
M
Kennelbloke
  • Solved
Excel Unique-Filter issue
Replies
3
Views
230
SkipVought
S
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
597
bs6600
bs6600
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
653
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top