Toggle Button to Format Cells

[tenghensen]

Hi All,

I am trying to code a toggle button to format a block of cells. Because I can only hide entire rows or columns, I am trying to just format the block of cells as ;;; so that the contents are hidden instead. If anyone can give me some code to do this, and show how to specify the cells that I want to format exactly, that would be really helpful.

Thanks

 

[Rick Rothstein]

Give this macro a try...

Sub ToggleCellVisibility()
  Dim RangeToToggle As Range
  Set RangeToToggle = [COLOR=#0000FF][B]Range("C3:F6")[/B][/COLOR]
  If RangeToToggle.NumberFormat = ";;;" Then
    RangeToToggle.NumberFormat = "General"
  Else
    RangeToToggle.NumberFormat = ";;;"
  End If
End Sub

Set your range in the highlighted section.