textbox scrollbar disappears

  • Thread starter Thread starter Yaniv
  • Start date Start date
Y

Yaniv

Hi

i have a textbox in my sheet.
i use the multiline option and the scrollbars option for that textbox.
when i enter text to the textbox, everything is fine (i can see the
scrollbar)
but if i close the sheet and open it again, the scrollbar for that textbox
disappears (so i can't tell that there are more lines in that textbox than
what i can see...)
only when i click in the textbox - the scrollbar reappears...

did anyone see that ?
is there a way to show the scrollbar when opening the file ?

thanks,
Yaniv
 
I see the same behavior in xl2003 (textboxes from the control toolbox toolbar).

But I don't have a workaround for you.
 
Untested...but it seems that if you have a workbook open event that
makes the text box active, it may force the scroll bar to appear.

Worth a shot....

Bruce
 
After I closed and reopened the workbook, I'd select the text box and I could
see the scrollbars. But when I selected a cell, the scrollbars went away.

(I didn't take the time to test it with code, though.)
 
Back
Top