Hi What is the best way to prevent users from modifying certain columns in an
Excel worksheet?

thanks,
Cath

Hi,

Protect the sheet by doing the following:

Tools Protection Protect Sheet

If you want to allow some cells to be unprotected, select these cells,
right click and:

Format Cells Protection Tab Uncheck 'Locked'

That should do it.

HTH,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=563717

Cath Wrote:
Hi What is the best way to prevent users from modifying certain columns
in an
Excel worksheet?

thanks,
Cath

The easiest way is to use sheet protection.

First, for any cells that you want the user to be able to modify, you
select Format - Cells... then choose the Protection tab, Uncheck the
box beside Locked, and hit OK.

Second, enable protection on the worksheet. Tools - Protection -
Protect Sheet... You'll get a popup wherein you can type a password.
At this point, any Locked cells can't be editted by your users, while
the Unlocked cells can be editted.

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=563717