Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Hide objects on click in Excel with VBA – How-to video

This quick and silent how-to video shows you how to Hide Objects on click in Excel with VBA.

Overview

So, this particular lesson is useful if you plan to provide user interaction with your program. Moreover, it is greate if you plan to create something more dynamic, like a game.

Video on how-to hide objects on click in Excel

Below is the video on how to make an Object invisible in Excel. Also, we have a previous video that allows you to show or display all objects in the program. That is useful if you want to bring back what you Hide.

YouTube how-to video on making objects disappear on click.

The code

' hide_Face
'   Hide just one individual face
Sub hide_Face(faceNum)
    ActiveSheet.Shapes.Range("shp_Face_" & faceNum).Visible = msoFalse
End Sub

So, you can show an individual piece too. Simply, change msoFalse to msoTrue on line 4. Of course, you would also change the words hide to show. Other than that, you are good-to-go.

Related

  • Show hide objects with Excel VBA – How-to video

Thank you for viewing this how-to lesson. If you want more training, then click on the button below.

How-to guides


Techronology home

The post Hide objects on click in Excel with VBA – How-to video appeared first on Techronology.



This post first appeared on Office Tools, Software Library, Design, Training, And Games | Techronology, please read the originial post: here

Share the post

Hide objects on click in Excel with VBA – How-to video

×

Subscribe to Office Tools, Software Library, Design, Training, And Games | Techronology

Get updates delivered right to your inbox!

Thank you for your subscription

×