bluejen512
04-04-2014, 01:54 AM
Hi Everyone - thanks for taking your time to help.
I have the exact same issue as this guy :
" have an Excel file used as a form that has a number of form controls in it (text boxes, combo boxes, etc.). This form worked fine until we upgraded to Office 365.
Now when users click in certain text boxes, the cursor to enter text becomes so small that the user doesn't think they are in the text box. However, if you type some text and then exit the text box, the text returns to normal size. This makes it impossible to actually edit text.
If I go into the properties of each text box and cycle the WordWrap property to "False" and the back to "True" the problem resolves itself until I exit the workbook and then open it again. Which text boxes are affected is completely random. There is no consistency that I can see as to which boxes will be a problem when I open the workbook "
The work around that Darren suggested of adding the following to the textbox gotfocus event :
textbox1.wordwrap = false
textbox1.wordwrap = true
This works for me but the problem i have is that i have around 4000 work sheets :(
Is there a way i modify this code to open every worksheet the same or do i really have to modify all 4000 worksheets?
Thanks for your help
Jenny
I have the exact same issue as this guy :
" have an Excel file used as a form that has a number of form controls in it (text boxes, combo boxes, etc.). This form worked fine until we upgraded to Office 365.
Now when users click in certain text boxes, the cursor to enter text becomes so small that the user doesn't think they are in the text box. However, if you type some text and then exit the text box, the text returns to normal size. This makes it impossible to actually edit text.
If I go into the properties of each text box and cycle the WordWrap property to "False" and the back to "True" the problem resolves itself until I exit the workbook and then open it again. Which text boxes are affected is completely random. There is no consistency that I can see as to which boxes will be a problem when I open the workbook "
The work around that Darren suggested of adding the following to the textbox gotfocus event :
textbox1.wordwrap = false
textbox1.wordwrap = true
This works for me but the problem i have is that i have around 4000 work sheets :(
Is there a way i modify this code to open every worksheet the same or do i really have to modify all 4000 worksheets?
Thanks for your help
Jenny