Hide object with VBA in Excel – Quiz

Home » Education » Hide object with VBA in Excel – Quiz

Hide object with VBA in Excel – Quiz

Released: February 8, 2024

Updated: March 16, 2024

By: Excel Effects

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!

Want to see everything, well almost everything on Excel Effects?

Excel Effects filing and organizational tools for your digital office needs.

Affiliate stuff – Move up and excel with Excel