|
-
Dec 20th, 2015, 05:43 AM
#1
Thread Starter
New Member
Selecting all shapes in a range in Excel (VBA)
I need all shapes within certain columns to dissapear/apear upon the click of a button. (Because shapes can be moved to other columns I do not want to specify the shapes in my code)
Hiding/showing all shapes on the sheet I can do (cf. code below), but not for a specific range.
Dim Sh as Shape
With ActiveSheet
For Each Sh In ActiveSheet.Shapes
If Sh.Type = msoGroup Then 'only grouped shapes need to appear/dissapear
Sh.Visible = msoTrue '/msoFalse
End If
Next Sh
End With
I've searched all over google for possible solutions, but don't find anything :-/
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|