I am using the Merged Cell Line Height Macro, and it is a great macro.

However I am having a problem with it. It works great on an unprotecte
worksheet, but when I protect the worksheet it causes the macro to hal
with an error.

My sheet is a report that is protected to prevent changes and allo
data entery only in allowed fields. The allowed fields are unlocked
merged cells. When the text entered is too long for the merged cel
width, I would like to be able to use the macro to have users easil
adjust the height. (<Ctrl h is the assigned name). It works grea
until I protect the worksheet. Once I protect the sheet, pressing <Ctr
h in the merged cell runs the macro, but it errors at the line "
.MergeCells = False".

I have tried playing with the options for the protection, but can'
seem to find a way to have the page protected, and still have the macr
be able to run.

Any ideas greatly appreciated

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com