View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KRCowen KRCowen is offline
external usenet poster
 
Posts: 21
Default Show & Hide Shape in a Sheet

Pete
I think you are overcomplicating things.

Private Sub ToggleButton1_Change()
ActiveSheet.Shapes("Rectangle 3").Visible = Not (ActiveSheet.Shapes("Rectangle
3").Visible)
End Sub

will probably do what you want.

Good luck.

Ken
Norfolk, Va