Thanks to Ken Johnson's help I have a Comment box which appears only if a
condition is met. This comment has been created by a small macro. It seems
that because the comment box is not a standard Excel comment, but has been
created by the macro, any attempt to format the text box (dimensions,
alignment, no shadow etc) fails. It looks like the formatting has to be
included in the macro, but so far I haven't been able to do this. Can anyone
help?