Disabled cells

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

Guest

Hi all,
How can i disable users to edit certain cells on the sheet and to display a
certain message whenever users fails to edit these cells ??
 
Change the cell to locked & any cell you want the user to alter to unlocked
and then protect the sheet under the tool - protection menu
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Pietro

Seems like this is a contradiction.

You want to disable users to edit certain cells but display a message if they
fail to edit these cells.

See help on cell locking and unlocking and Sheet Protection.


Gord Dibben MS Excel MVP
 
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

Locking Cells 2
Cell in new sheet should always refer to defined cell in another s 8
Protection 1
Locked Property off, but cannot select cell 3
Protect sheet with permissions? 3
Can I protect data in a cell, but allow comments to be entered. 6
Unprotecting worksheets 2
pop up vs. data validation 7

Back
Top