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

Protecting formulas but allowing data to be changed 2

Status
Not open for further replies.
Lil8

Lil8

Technical User
Oct 24, 2003
42
GB
Is there any way of preventing formulas from being deleted / changed whilst allowing for data to be changed in a Worksheet in Excel 2000 ? I can protect the formula or hide it but this then does not allow any data to be changed in the worksheet.

Nic
 
Sort by date Sort by votes
You need to protect/unprotect each cell individualy. The default is locked so when you protect the sheet using 'Tools->Protection->Protect' you lock all of the cells. Select the cell or cells you want to modify, right click and select the 'Format Cells...' option then select the 'Protection' tab and then unlock the cells that you want people to be able to modify. Then use the 'Tools->Protection->Protect' option to lock the whole sheet.

Hope this helps.
Les....
 
Upvote 0 Downvote
Many thanks, just what I needed.

Slán agus beannacht.
Patrick Boland
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Damnitalldaddy
  • Locked
  • Question
excel formulas
Replies
1
Views
247
mintjulep
M
ladyck3
  • Locked
  • Question
EXCEL - I'm starting a new project but have to say... to all...
Replies
2
Views
367
ladyck3
ladyck3
Wicca
  • Locked
  • Question
MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another
Replies
16
Views
757
Wicca
Wicca
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
652
combo
combo
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo

Part and Inventory Search

Sponsor

Back
Top