Worksheet in a worksheet?
 

Thanks Dave but I don't have Excel Workbook as a choice in the object type
box when I use insert/object?
Regards
Philip

"Dave Peterson" wrote in message
...
I don't think so.

You can insert a workbook into a worksheet, though. Just like a .doc file
(insert|object).

Philip Reece-Heal wrote:

Is there any way to insert a worksheet in an Excel worksheet, like you
can
insert a Word document in an Excel worksheet?

Regards
Philip

--

Dave Peterson

I'd cheat. I'd create a workbook and save it (and close it).

Then add that object from an existing file (Create from file tab).

Philip Reece-Heal wrote:

Thanks Dave but I don't have Excel Workbook as a choice in the object type
box when I use insert/object?
Regards
Philip

"Dave Peterson" wrote in message
...
I don't think so.

You can insert a workbook into a worksheet, though. Just like a .doc file
(insert|object).

Philip Reece-Heal wrote:

Is there any way to insert a worksheet in an Excel worksheet, like you
can
insert a Word document in an Excel worksheet?

Regards
Philip

--

Dave Peterson

--

Dave Peterson

I see what you mean Dave
Thanks


"Dave Peterson" wrote in message
...
I'd cheat. I'd create a workbook and save it (and close it).

Then add that object from an existing file (Create from file tab).

Philip Reece-Heal wrote:

Thanks Dave but I don't have Excel Workbook as a choice in the object
type
box when I use insert/object?
Regards
Philip

"Dave Peterson" wrote in message
...
I don't think so.

You can insert a workbook into a worksheet, though. Just like a .doc
file
(insert|object).

Philip Reece-Heal wrote:

Is there any way to insert a worksheet in an Excel worksheet, like you
can
insert a Word document in an Excel worksheet?

Regards
Philip

--

Dave Peterson

--

Dave Peterson

I've seen (in xl2003) a worksheet "inside" a Userform on a worksheet. The
spreadsheet contol is in the toolbox to add click on -- Other Controls; look
for Microsoft excel Ver 11.0, select, OK out.
The add it inside a Userform you've created.
HTH

"Philip Reece-Heal" wrote in message
...
Is there any way to insert a worksheet in an Excel worksheet, like you can
insert a Word document in an Excel worksheet?

Regards
Philip