#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Wrap Issue clara New Users to Excel 5 June 6th 08 10:01 PM
Text Wrap Issue Steved Excel Worksheet Functions 0 April 20th 08 11:04 PM
Copy from Word to Excel, and retain indent, plus word wrap Eric Excel Discussion (Misc queries) 1 March 9th 07 03:15 AM
word wrap dfresh34 Excel Discussion (Misc queries) 1 October 25th 06 04:45 PM
Wrap Text issue jsAlpha Excel Discussion (Misc queries) 2 January 5th 06 01:56 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"