Visible property of object

Posted by Adam K. on February 23, 2000 10:48 AM

i have a picture that i want to pop up. i am going to make the visible property true. my questions is how do you start off by having it false and not be visible

thanks

Posted by Celia on February 23, 2000 4:43 PM

Adam

To hide your picture
ActiveWorkbook.DisplayDrawingObjects = xlHide

To show your picture
ActiveWorkbook.DisplayDrawingObjects = xlDisplayShapes

Celia
(PS. Above code is easily found from VBA help)