Thread
:
Picture Painting
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
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
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge