Hello -

For some reason, I am not able to set the right-hand margin of a multiline
textbox. Users want to print the document and the text is cut off on the
right-hand side.

The Excel help files say to select the textbox, and on the Format menu,
click the Margins tab and under Internal margin, adjust the measurements. I
do not have that option under format, or anything else for that matter. I
can't even find it amongst the properties in intellisense.

Any help will be greatly appreciated!
--
Sandy

That is for the textbox from the drawing toolbar. Is that what you are
using. Is it on a worksheet.

If you are using that textbox, you need to right click on the outer, thick
selection boarder to get a format dialog that has 8 tabs.
--
Regards,
Tom Ogilvy

"Sandy" wrote in message
...
Hello -

For some reason, I am not able to set the right-hand margin of a multiline
textbox. Users want to print the document and the text is cut off on the
right-hand side.

The Excel help files say to select the textbox, and on the Format menu,
click the Margins tab and under Internal margin, adjust the measurements.
I
do not have that option under format, or anything else for that matter. I
can't even find it amongst the properties in intellisense.

Any help will be greatly appreciated!
--
Sandy

Hi Tom -

Thanks for your reply!

It's the textbox from the Control Toolbox toolbar.

(I tried throwing in a box from the drawing toolbar just to see what that
would do -- I've never used an autoshape for a textbox before. I was able to
get the thick line you mentioned, and thus, the 8-tab dialog you are talking
about, just once! What's the trick to that?)

At any rate, how do I get this dialog from the textbox from the Control
Toolbox toolbar, or is setting the internal margin something that has to be
done with code?
--
Sandy


"Tom Ogilvy" wrote:

That is for the textbox from the drawing toolbar. Is that what you are
using. Is it on a worksheet.

If you are using that textbox, you need to right click on the outer, thick
selection boarder to get a format dialog that has 8 tabs.
--
Regards,
Tom Ogilvy

"Sandy" wrote in message
...
Hello -

For some reason, I am not able to set the right-hand margin of a multiline
textbox. Users want to print the document and the text is cut off on the
right-hand side.

The Excel help files say to select the textbox, and on the Format menu,
click the Margins tab and under Internal margin, adjust the measurements.
I
do not have that option under format, or anything else for that matter. I
can't even find it amongst the properties in intellisense.

Any help will be greatly appreciated!
--
Sandy

in the drawing toolbar, click the second button (the northwest arrow) which
puts you in a type of design mode. then select the textbox and right click
on it. When done, click the button again.

--
Regards,
Tom Ogilvy

"Sandy" wrote in message
...
Hi Tom -

Thanks for your reply!

It's the textbox from the Control Toolbox toolbar.

(I tried throwing in a box from the drawing toolbar just to see what that
would do -- I've never used an autoshape for a textbox before. I was able
to
get the thick line you mentioned, and thus, the 8-tab dialog you are
talking
about, just once! What's the trick to that?)

At any rate, how do I get this dialog from the textbox from the Control
Toolbox toolbar, or is setting the internal margin something that has to
be
done with code?
--
Sandy


"Tom Ogilvy" wrote:

That is for the textbox from the drawing toolbar. Is that what you are
using. Is it on a worksheet.

If you are using that textbox, you need to right click on the outer,
thick
selection boarder to get a format dialog that has 8 tabs.
--
Regards,
Tom Ogilvy

"Sandy" wrote in message
...
Hello -

For some reason, I am not able to set the right-hand margin of a
multiline
textbox. Users want to print the document and the text is cut off on
the
right-hand side.

The Excel help files say to select the textbox, and on the Format
menu,
click the Margins tab and under Internal margin, adjust the
measurements.
I
do not have that option under format, or anything else for that
matter. I
can't even find it amongst the properties in intellisense.

Any help will be greatly appreciated!
--
Sandy

Thanks yet again, Tom!
--
Sandy


"Tom Ogilvy" wrote:

in the drawing toolbar, click the second button (the northwest arrow) which
puts you in a type of design mode. then select the textbox and right click
on it. When done, click the button again.

--
Regards,
Tom Ogilvy

"Sandy" wrote in message
...
Hi Tom -

Thanks for your reply!

It's the textbox from the Control Toolbox toolbar.

(I tried throwing in a box from the drawing toolbar just to see what that
would do -- I've never used an autoshape for a textbox before. I was able
to
get the thick line you mentioned, and thus, the 8-tab dialog you are
talking
about, just once! What's the trick to that?)

At any rate, how do I get this dialog from the textbox from the Control
Toolbox toolbar, or is setting the internal margin something that has to
be
done with code?
--
Sandy


"Tom Ogilvy" wrote:

That is for the textbox from the drawing toolbar. Is that what you are
using. Is it on a worksheet.

If you are using that textbox, you need to right click on the outer,
thick
selection boarder to get a format dialog that has 8 tabs.
--
Regards,
Tom Ogilvy

"Sandy" wrote in message
...
Hello -

For some reason, I am not able to set the right-hand margin of a
multiline
textbox. Users want to print the document and the text is cut off on
the
right-hand side.

The Excel help files say to select the textbox, and on the Format
menu,
click the Margins tab and under Internal margin, adjust the
measurements.
I
do not have that option under format, or anything else for that
matter. I
can't even find it amongst the properties in intellisense.

Any help will be greatly appreciated!
--
Sandy