Comment boxes

[Anthony]

Hi,

Is there a limit to the number of comment boxes a worksheet / work book can
have.

I need to display some information against certain lines of data and the
easiest way is to use a comments box.

There could be a max of 1000 comment boxes need on a single sheet and there
are 2 sheets.

So 2000 in the whole workbook would be the maximum, bt they are only added
if criteria is met.


Regards


Anthony

p.s office 07 in compatibility mode 03

 

[JLGWhiz]

The number of comments is limited by your system resources, but the amount
of data within the comment is liimited. I am not sure what that limit is.

 

[Anthony]

Thank you. The size of the comments will be small.

It should be fine with what I have planned

Regards


Anthony