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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Protecting cells in Excel

Status
Not open for further replies.
Caspers

Caspers

Technical User
Nov 22, 2002
19
GB
It is possible rather than protecting a whole worksheet just to protect individual cells or groups of cells within a worksheet instead.
 
Sort by date Sort by votes
It is not possible, but you can unlock some cells (protection tab in cell formatting). This allows to change their contents when worksheet is protected.

combo
 
Upvote 0 Downvote
Actually, it is possible - but only in XP. You can protect different parts of a worksheet (even for different users)

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
260
N1GHTEYES
N1GHTEYES
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
291
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
287
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
863
shytott
shytott
renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
638
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top