title: Change text & Background of a Toggle Button
body: <p>i have a toggle button that can hide me the chart but i want it to be more designed.</p>
  <p>I would like that when the chart is <strong>hidden</strong> that the button text is 'Show' and backgroundcolor is Red and when <strong>he is show</strong>, the button is 'Hidden' and background color is Black.</p>
  <p>This is my VBA code :</p>
  <pre><code>Option Explicit
  
  Sub hidechart()
      
      With ThisWorkbook.Worksheets(&quot;CA&quot;).Range(&quot;45:74,118:147, 192:220, 265:292&quot;)
          .EntireRow.Hidden = Not .EntireRow.Hidden
      End With
  
  End Sub
  </code></pre>