Proctecting certain cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to protect the cells with formulas, but still allow other users to use
the worksheet. Please Help
 
You will need to follow this protocol:
1) Select all cell you want users to be able to change; use Format|Cells and
Unlock them in the Protection tab
2)Use Tool|Protection->Protect Worksheet
best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Hide, Unhide, and auto filter - select all on a protected sh 1
Excel 2003 - Protecting Cells but allowing external data updates 3
How do you prevent users from changing certain cells? 4
Excel VBA 1
Protecting Excel Formulas 2
Tabbed cells 1
using Spell check on protected sheet 6
Edit links when the sheet is protected 3

Back
Top