View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default Picture Painting

Bill

Why not hide it in the workbook_Close() event. This way it will be hidden
on the last close and hence the next open

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"billq" wrote in message
...
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