View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chilired Chilired is offline
external usenet poster
 
Posts: 21
Default Re-size Comments Box

I utlized Debra Dalgleish Resize Comments macro on a sheet that is protected.
It appeared to work okay, however the larger comments runs off the screen to
the left and users are not permitted to scroll up or down in the comments.
How can I use auto-size, but limit the widith of the box so it remains
visible on the screen without making all the boxes the same size?

Chilired.