Pop up spreadsheet in excel 2007

[pololuck]

I am trying to make spreadsheets pop up when selecting them and leaving the result of the equation only when closing them. I have attached a basic sample. If someone can show me how to do this and then leave descriptions in the code so that I can edit it.

[royUK]

What do you mean by "spreadsheets pop up"?

[pololuck]

I want the sheet where I calculate the volumes to open inside the main sheet, then be able to close it and have the results show up in one cell. The way the calendar or calculator pop up.