View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sue Sue is offline
external usenet poster
 
Posts: 285
Default Programmatically hide an object - Excel 2003 or 2007

We have a need to programmatically hide some objects in Excel. We can do it
in PowerPoint because it is easy to define the slide number and object
number. But how to do it in Excel?

My searches through Help only show how to hide a worksheet.

This is what we currently have:
Sub Hide_Objects()
ActiveSheet.Shapes("Object 1").Visible = False
ActiveSheet.Shapes("Object 2").Visible = False
End Sub

Thank you for any help