unselect shape

**mmf** · 06-09-2008, 06:33 AM

Hi Fellows
I am doing a sub to handle some shapes, but I do not know how to unselect the sape once I performed the changes, any hint?
I was trying things like selection.clear, but dind't work at all

thanks

Please Login or Register  to view this content.

**royUK** · 06-09-2008, 06:42 AM

Select a cell to deselect the shape, place this at the end of the code

Please Login or Register  to view this content.

**mmf** · 06-09-2008, 07:05 AM

Thanks roy, very simple solution

**Andy Pope** · 06-09-2008, 07:09 AM

Or don't select it in the first place

Please Login or Register  to view this content.

**mmf** · 06-09-2008, 08:58 AM

ahhhh!

What I wanted
Many thanks for that suggestion

**plotweaver2934** · 01-10-2019, 07:11 PM

My learned Excel experts... For all the versatility offered by this program... one would think there would be a very elegant and simply command for deselecting shapes. Such as:

Selection.ShapeRange.UnselectAll

or perhaps...

Selection.ShapeRange.Select = False

Instead we have to select a phantom cell or some such nonsense. Forgive my insolence. But, if we can Ungroup, why not Unselect?
Example: Selection.ShapeRange.Ungroup.Select

Thanks for your patience.

**scottiex** · 01-10-2019, 08:19 PM

What state do you want selection to be in after that?
Usually when you go to excel a specific cell is selected.

**plotweaver2934** · 01-10-2019, 11:02 PM

I'm not the typical user. I'm creating a game with Excel for test purposes. So, need to select and deselect shapes without having to select cell to do it. Tried Escape Key, but didn't work. Any better solution?

**FDibbins** · 01-11-2019, 12:59 AM

plotweaver2934 welcome to the forum

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.