First code, use:
Activesheet.protect UserInterfaceOnly:=true
to protect the sheet.

Second code, don't use merged cells! Are you wanting to clear data from
merged cells? or are these cells headers?
If the merged cells are cells from the same row then use -Centre across
selection- in the -Horizontal -section of the -Text Alignment- section
of the -Alignment -tab of the -Format Cells- dialogue box *instead* of
merging them.

berniean;436168 Wrote:
Thank you for the response. Unfortunately, the first code doesn't work
on
protected sheets. The second code started to work but stopped when it
hit a
merged cell. I get "Run time error '1004': Cannot change part of a
merged
cell." Do you know of a way around that?
Thanks again, Bernie


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120852