textbox scrollbar disappears

[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

 

[Dave Peterson]

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

But I don't have a workaround for you.

 

[swatsp0p]

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

 

[Dave Peterson]

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.)