Thread: word wrap issue
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default word wrap issue

It may be that a change event macro is running. If your macro security is
Medium and you were prompted to enable macros that is a possibility. Since
the workbook is shared you cannot check for code without unsharing it. If
you do that you can then right click on the worksheet's tab and click View
Code. You'd be looking for Sub Worksheet_Change although any code may be
suspect. Change event code can also be in the ThisWorkbook module.

--
Jim
"eddieray" wrote in message
...
|I have a small (200 row) filtered, shared spreadsheet. One column is for
| "comments". I am having several issues:
|
| 1) even when I remove word wrap from the entire column, once an entry has
| been made by a user, word wrap is automatically turned back on. Whice
| appears to lead to.....
|
| 2) occasionally after a user inputs comments, the column size changes to
| show all the comments. This is undesireable as the comments can be quite
| long and is there to reference, not to constantly display.
|
| Any ideas? Thanks!