View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
billQ billQ is offline
external usenet poster
 
Posts: 16
Default Picture Painting

I have a picture which I would like to hide until a particular cell is
pressed. I need to know which function to use when the work book opens to
hide the object with Sheet1.Shapes("Picture32").Visible = False. I have
tried Workbook_WindowActivate, Activate, and the Open workbook fucntions.
All 3 place the picture on the screen for a second before the function runs
to hide it. Any help would be appreciated.
thanks
bill