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 ?


--
qwertyjjj
------------------------------------------------------------------------
qwertyjjj's Profile: http://www.excelforum.com/member.php...o&userid=37489
View this thread: http://www.excelforum.com/showthread...hreadid=571441

protect columns (prevent addition or deletion)
 

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

protect columns (prevent addition or deletion)
 

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

protect columns (prevent addition or deletion)
 

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" wrote
in message ...

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