Guest User

Untitled

a guest
Mar 22nd, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. sub SupressZeros
  2.  
  3. set chart = ActiveDocument.GetSheetObject("CH09")
  4. set cp = chart.GetProperties
  5.  
  6. set mytext = ActiveDocument.GetSheetObject("TX95")
  7. prop = mytext.GetProperties
  8.  
  9. if cp.SuppressZero then
  10. cp.SuppressZero = false
  11. prop.Layout.Text.v = "Supress Zeros"
  12. else
  13. cp.SuppressZero = true
  14. prop.Layout.Text.v = "Show Zeros"
  15. end if
  16.  
  17. chart.SetProperties cp
  18. mytext.SetProperties prop
  19.  
  20. end sub
Add Comment
Please, Sign In to add comment