View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Memo Control in Excel XP

Embed a textbox from the Control Toolbox in the cell and set the properties to
have a vertical scrollbar.

Also set multiline and wordwrap to TRUE


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 07:32:01 -0800, johnb
wrote:

Hi all
I have protected spreadsheet that get emailed to suppliers who fill in the
reasons etc. (in the unprotected cells) and returned to sender.

In one cell the explanation can be quite verbose so I have been asked to
place a vertical scrol bar on that cell.

How do I do that or whats a work-a-round?
TIA
johnb