Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Wrap Issue | New Users to Excel | |||
Text Wrap Issue | Excel Worksheet Functions | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
word wrap | Excel Discussion (Misc queries) | |||
Wrap Text issue | Excel Discussion (Misc queries) |