Is there a way to insert a word document into a single cell of an excel
worksheet that would not expand the cell yet give you full veiw of the
document if you scrolled over the cell.
Let's say for example I am creating a schedule on a calender. I want to see
the heading of the word document when I open the excel workbook but want the
calender to remain the same size unless I scroll over the cell that holds the
information I need.

I have used a similar technique (not word documents) by dynamically changing
the cell comments text and size - it might be a way forward?

With Range("A1")
.AddComment
.Comment.Visible = False
.Comment.Text Text:="This is a new comment"
.Comment.Shape.ScaleWidth 2.16, msoFalse, msoScaleFromTopLeft
.Comment.Shape.ScaleHeight 1.74, msoFalse, msoScaleFromTopLeft
End With

I guess there is no reason why a word document could not be opened and
pasted into the comment - not sure about format and size restrictions?

--
Cheers
Nigel



"Marty in Austin" <Marty in wrote in
message ...
Is there a way to insert a word document into a single cell of an excel
worksheet that would not expand the cell yet give you full veiw of the
document if you scrolled over the cell.
Let's say for example I am creating a schedule on a calender. I want to
see
the heading of the word document when I open the excel workbook but want
the
calender to remain the same size unless I scroll over the cell that holds
the
information I need.

Hello Nigel,

The method you used sounds interesting. Please explain a little further.
First question: Does the comment fill the viewable surface of the cell or
does it appear as a tag? Second question: Does this method allow the user or
viewer to print the contents of the single cell by just clicking the cell and
the print button? Third question: If the answer to the second question is
yes, can you format the comment to appear to be a word document when printed?
Thank you so much Nigel for your time and thoughts.

Marty

"Nigel" wrote:

I have used a similar technique (not word documents) by dynamically changing
the cell comments text and size - it might be a way forward?

With Range("A1")
.AddComment
.Comment.Visible = False
.Comment.Text Text:="This is a new comment"
.Comment.Shape.ScaleWidth 2.16, msoFalse, msoScaleFromTopLeft
.Comment.Shape.ScaleHeight 1.74, msoFalse, msoScaleFromTopLeft
End With

I guess there is no reason why a word document could not be opened and
pasted into the comment - not sure about format and size restrictions?

--
Cheers
Nigel



"Marty in Austin" <Marty in wrote in
message ...
Is there a way to insert a word document into a single cell of an excel
worksheet that would not expand the cell yet give you full veiw of the
document if you scrolled over the cell.
Let's say for example I am creating a schedule on a calender. I want to
see
the heading of the word document when I open the excel workbook but want
the
calender to remain the same size unless I scroll over the cell that holds
the
information I need.