| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Memo Control in Excel XP
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using version control in Excel 2003 | Excel Discussion (Misc queries) | |||
| how do I set up stock control sheet in excel | Excel Worksheet Functions | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) | |||
| how to delete or remove checkbox form control in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
