View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Setting right-hand internal margin in textbox

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