MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)