View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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