title: How to show/hide data from a table in Powerpoint?
body: <p>I'm trying to have several slides with tables, each table has 3 columns, the last column is the "reference value" and I want it to be hidden during the presentation and show it only by pressing a button or a hyperlink, each row individually. I think it's possible because I'm really new at coding and I have managed to do it by changing the cell's text format from white (which is the table's background color)  to red, but I can only do it for all the tables at once, and I need individual values on each one of them. (I hope I'm making myself clear). This is what I have done so far:</p>
  
  <pre><code>Sub format()
  
  Dim s As Slide
  Dim oSh As Shape
  Dim oTbl As Table
  
  
  For Each s In ActivePresentation.Slides
  
  For Each oSh In s.Shapes
      If oSh.HasTable Then
          Set oTbl = oSh.Table
  
         With oTbl.Cell(2, 3).Shape.TextFrame.TextRange
                      .Text = "4500-9000"
                       .Font.Size = 12
                      .Font.Color = vbRed
                  End With
      End If
  Next
  Next s
  End Sub
  </code></pre>
  
  <p>But this will change the same cell on every table I have, I want it to change specific cells in specific tables one by one, since they all have different valued. I know I could do this with animations, but I'd rather do it this way. </p>
  
  <p>EDIT: It would be great if, instead of pressing a button, I could get the data by hovering the pointer over the empty cell, and have it hidden away again when I hover the cursor off the cell.</p>
  
  <p>In any case, whenever I do any change to the presentation during slideshow, the change will still be there at the end, which means It would only work once and then I would have to fix and hide all the values again, is there a way to restore the changes done during the presentation when it ends?</p>