PDA

View Full Version : Show and Hide Label



Tav29
10-04-2007, 10:45 AM
I have a label on multiple worksheets, I want to hide or show the label if a specific cell is null.

Bob Phillips
10-04-2007, 10:59 AM
Dim sh As Worksheet

On Error Resume Next
For Each sh In ActiveWorkbook.Worksheets
sh.OLEObjects("labelname").Visible = sh.Range("C3").Value <> ""
Next sh

Tav29
10-04-2007, 11:11 AM
Thank you....