Worksheet in a worksheet?

P

Philip Reece-Heal

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
 
B

bigwheel

Have you tried Insert>Object>Create from File - enter the filename and check
the Display as icon checkbox
 
D

Dave Peterson

I don't think so.

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

Philip Reece-Heal

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

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).
 
P

Philip Reece-Heal

I see what you mean Dave
Thanks


Dave Peterson said:
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).
Click to expand...
 
J

Jim May

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
 
Top