Show / Hide Label

  • Thread starter Thread starter Guest
  • Start date Start date
I got it...

On Error Resume Next
For Each sh In ActiveWorkbook.Worksheets
sh.OLEObjects("label1").Visible = sh.Range("D3").Value <> ""
Next sh
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding 0 value data labels in chart 8
userform label set enter 6
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Iterating through each label on a worksheet 1
Inside Base Series Label Showing #N/A 0
show userform/hide workbook 7
macro to show / hide grouping, linked to label button 3
Excel Changing chart label colors based on a value in a cell 0

Back
Top