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