[Ray Clark]

I have a number of text boxes set up in an Excel spreadsheet and am trying to
print preview only the text box and not the whole spreadsheet. Is there a
way of selecting a text box and doing a print preview of this text box.
Having problems trying to find any code to achieve this.

Thanks Ray

Archived from group: microsoft>public>vb>directx

[Ralph]

"Ray Clark" wrote in message@microsoft.com...
> I have a number of text boxes set up in an Excel spreadsheet and am trying
to
> print preview only the text box and not the whole spreadsheet. Is there a
> way of selecting a text box and doing a print preview of this text box.
> Having problems trying to find any code to achieve this.
>
> Thanks Ray

I'm probably missing something, but you should be able to set the print area
to include the Textboxes. Create a quick macro in Excel and then examine the
code.

By the way, this newsgroup is not the place to post this kind of question.
You should probably post to an Excel Developers group.

hth
-ralph

[Ray Clark]

"Ralph" wrote:

>
> "Ray Clark" wrote in message
> @microsoft.com...
> > I have a number of text boxes set up in an Excel spreadsheet and am trying
> to
> > print preview only the text box and not the whole spreadsheet. Is there a
> > way of selecting a text box and doing a print preview of this text box.
> > Having problems trying to find any code to achieve this.
> >
> > Thanks Ray
>
> I'm probably missing something, but you should be able to set the print area
> to include the Textboxes. Create a quick macro in Excel and then examine the
> code.
>
> By the way, this newsgroup is not the place to post this kind of question.
> You should probably post to an Excel Developers group.
>
> hth
> -ralph
>
> Thanks Ralph I was looking at every other way but this one. Will try to make sure that I post to the correct group.

Ray
>