Read this You will be able to do this with yourself
http://blogs.office.com/b/microsoft-excel/archive/2006/07/17/office-web-comp onents-roadmap.aspx Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chris Sent: 14 September 2012 7:02 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Spreadsheet within Spreadsheet Hey guys, trying to take Excel to the next level here for a budget template design that I have in mind. Is it possible to have a spreadsheet within a spreadsheet? Let me clarfiy: I'd like to insert for a certain portion of the screen, another spreadsheet within my original spreadsheet. That "window" should be scrollable and when clicking on contents in that embedded spreadsheet, I'd like to have the outter "mother" spreadsheet change its contents. Or vice versa, when selecting and clicking on items on the outer spreadsheet, the contents of the embedded spreadsheet should change. I have been able to embed a spreadsheet object in my original spreadsheet. However, to maniuplate the contents, you always have to double click the embedded object first, it then opens up all the way, etc. That's not the effect I'm looking for. Are there other objects I could possibly use for this idea? Maybe somebody has a sample to share? Thanks for your help in advance, Chris -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
