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

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