protect columns (prevent addition or deletion)

I have a spreadsheet used in conjunction with an Access database.
I would like to prevent users from adding or deleting columns in any of the worksheets, but at the same time, allow them to make as many changes as they want to the cells of the columns.
Is this possible ?

the default for a protected sheet is not to allow column or row deleting

You could unlock all the cells and protect the sheet. xl2002 and later
offer several options associated with protecting the sheet that may make this
more tenable.

--
Regards,
Tom Ogilvy


"qwertyjjj" wrote:

>
> I have a spreadsheet used in conjunction with an Access database.
> I would like to prevent users from adding or deleting columns in any of
> the worksheets, but at the same time, allow them to make as many changes
> as they want to the cells of the columns.
> Is this possible ?
>
>
> --
> qwertyjjj
> ------------------------------------------------------------------------
> qwertyjjj's Profile: http://www.excelforum.com/member.php...o&userid=37489
> View this thread: http://www.excelforum.com/showthread...hreadid=571441
>
>

It's more that the top row of each worksheet contains column names, which I want to protect as they match up directly with my database column names in Access.
I can stop column deletion/addition by protectin the worksheet but is it possible to lock 1 row (the top row only)?

If you set .Locked=False for all the data cells that the user can change,
whilst the header cells are .Locked=True, then protect the sheet, does
achieve your aim ?

NickHK

"qwertyjjj" <[email protected]> wrote
in message news:[email protected]...
>
> It's more that the top row of each worksheet contains column names,
> which I want to protect as they match up directly with my database
> column names in Access.
> I can stop column deletion/addition by protectin the worksheet but is
> it possible to lock 1 row (the top row only)?
>
>
> --
> qwertyjjj
> ------------------------------------------------------------------------
> qwertyjjj's Profile:
http://www.excelforum.com/member.php...o&userid=37489
> View this thread: http://www.excelforum.com/showthread...hreadid=571441
>