Hide object with VBA in Excel - Quiz

Question on how to hide object in Excel with VBA

What VBA line of code would you use to hide the named shpSaucer object in Excel? Select your answer below, and try not to take a sneak peak.

A. Shapes.Range(“shpSaucer”).Show = False

B. Shapes.Range(“shpSaucer”).Visible = msoFalse

C. Shapes.Range(“shpSaucer”).Hide = msoTrue

D. Shapes.Range(“shpSaucer”).Display = Visible

Click the button below to view the answer.

B. Shapes.Range(“shpSaucer”).Visible = msoFalse

Fortunately, we have a video on the question at hand. Click on the silent video below to learn how to toggle the visibility of an object in Excel.

Show or hide a spaceship or any shape or image in Excel – Online video – Excel Effects on YouTube – https://youtu.be/_GKhhT7xjxQ

Also, do not forget to subscribe to Excel Effects on YouTube, which does not cost a thing. Thanks and enjoy!