SOLVED

Where do I find this definition

%3CLINGO-SUB%20id%3D%22lingo-sub-2739537%22%20slang%3D%22en-US%22%3EWhere%20do%20I%20find%20this%20definition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2739537%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20VBA%20code%20that%20includes%20the%20statement%20below.%20%26nbsp%3BWhere%20do%20I%20find%20the%20shape%20that%20is%20named%20in%20the%20quotes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EActiveSheet.Shapes(%22ExternalPontoon%22).Visible%20%3D%20False%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2739537%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2739571%22%20slang%3D%22en-US%22%3ERe%3A%20Where%20do%20I%20find%20this%20definition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2739571%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893335%22%20target%3D%22_blank%22%3E%40jragan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20the%20Hometab%20of%20the%20ribbon%2C%20in%20the%20Editing%20group%2C%20select%20Find%20%26amp%3B%20Select%20%26gt%3B%20Selection%20Pane...%3C%2FP%3E%0A%3CP%3EYou%20should%20see%20a%20list%20of%20all%20shapes%20on%20the%20worksheet.%20Clicking%20on%20a%20name%20will%20select%20the%20corresponding%20shape.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2739615%22%20slang%3D%22en-US%22%3ERe%3A%20Where%20do%20I%20find%20this%20definition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2739615%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFantastic!!!%20Thank%20you.%26nbsp%3B%20Now%20can%20you%20direct%20me%20to%20instructions%20as%20to%20how%20to%20create%20additional%20shapes%3F%26nbsp%3B%20I%20need%20to%20define%20additional%20shapes%20for%20code%20that%20I%20have%20added%20and%20do%20not%20have%20shapes%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have VBA code that includes the statement below.  Where do I find the shape that is named in the quotes?

 

ActiveSheet.Shapes("ExternalPontoon").Visible = False

 

Thanks.

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@jragan 

On the Hometab of the ribbon, in the Editing group, select Find & Select > Selection Pane...

You should see a list of all shapes on the worksheet. Clicking on a name will select the corresponding shape.

@Hans Vogelaar 

 

Fantastic!!! Thank you.  Now can you direct me to instructions as to how to create additional shapes?  I need to define additional shapes for code that I have added and do not have shapes for.

 

Thank you very much!

 

John

@jragan 

Activate the Insert tab of the ribbon.

In the Illustrations group, click the Shapes dropdown.

Select a shape, then either click in the sheet where you want the shape, or click-and-drag.

After inserting a shape, right-click it and select Assign Macro from the context menu if you want to run a macro when the shape is left-clicked.