+ Reply to Thread
Results 1 to 3 of 3

Trying to think outside of the box while showing only the inside of the box

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Trying to think outside of the box while showing only the inside of the box

    Hi All,.

    I am working on a way to make a presentation to a group wherein the first page of the workbook summarizes information from the following pages. Some of the information on the workbook pages should not be visible to the entire audience. By using Sky Drive, I am able to have several people logged in to the same excel document using the same log in information. This works great for me in that I am able to have several people inputting information into the individual workbook pages (with the private info) with only the summary page showing to my audience (all the non-private info.)

    My question for you, oh Super Geniuses of the world known as Excel, is whether or not there is a way to make only the information in the cells visible on the summary page. In other words, all the audience would see is the cells being updated, there would be no ribbon, column headings, etc - just the rectangle containing the information. Do I need to embed the spread sheet itself into a Word or PowerPoint document, and by doing so does that mean that it no longer updates in live time? Such a quandry......

  2. #2
    Forum Contributor
    Join Date
    01-30-2013
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    231

    Re: Trying to think outside of the box while showing only the inside of the box

    Try the Camera tool. Add the Camera to a toolbar.

    It takes a picture of another range of cells and displays what is on those other cells. Seems to be exactly what you are describing.

    Best of luck

    Chris

  3. #3
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Trying to think outside of the box while showing only the inside of the box

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 09-25-2013, 06:26 PM
  2. Replies: 1
    Last Post: 10-02-2012, 04:27 PM
  3. Toggle Button to Hide column A while showing B and hide B while showing A
    By glee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2011, 02:02 PM
  4. Running a SUB inside of another SUB
    By gmcconnell in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-09-2009, 11:55 AM
  5. Replies: 1
    Last Post: 07-20-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1