word wrap issue
 

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!

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!