Thread: VB code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default VB code

Good day.

I have created check boxes that control hiding and unhiding columns and rows
in one workbook writing the following code to control the hiding and unhiding.

Private Sub Worksheet_Calculate()

If Range("b5").Value = False Then
Columns("c:p").EntireColumn.Hidden = True
Else
Columns("c:p").EntireColumn.Hidden = False
End If

End Sub

I have since opened a new workbook, created another checkbox and used the
same code with absolutely no luck. I have checked my Macro settings in both,
which are both set to "low".

I am completely baffled.

Any suggestions?
--
Tom