Sub wohooo() Dim A1, B1, C2 As String A1 = range("M3").Value B2 = range("N3").Value For r = A1 To B1 C1 = "Picture" & " " & r Activesheet.shapes(r).visible = Not ActiveSheet.Shapes(r).Visible Next End Sub
Thanks for theses videos. This is what I have been searching for. However, is there a way to hide the developer table, copying options on files located on a desktop with vba?
what if the object is an object? Like an image you just pasted into the sheet? I find sometimes if you insert it as a picture, the image shows up blurry, as opposed to just pasting it there. It's name then appears as 'object #'. How do I manipulate that using 'ActiveSheet' in VBA?
Thankk you so much💓💓💓💓💓💓💓. No I will try to apply the dim features with this so this can automatically hide pictures objects in my excel. 💓💓 Thank you so much for this super amazing information
How to hide an activeshape? For instance, there are 100 shapes in the active window, and I want to hide the selected shape? For example my friend clicked the shape, and now my task is to hide that shape. How can I hide it automatically w/out the need of knowing its name? Is there a word or code ActiveShape as like as ActiveCell?
One thing I have done to hide multiple items at the same time is to group all the items together and hide that group instead of the individual items. I may do a video on how to do this.
I'm totally puzzled on how to hide shapes that are not hidden when rows are hid. It is so annoying how excel not shapes when rows of that shape are hidden. It still shows.
This is EXACTLY what I needed :) THANK YOU!!!
Just what I needed! Thank you.
I'm glad it helped.
Clear and simple👍
How can I hide/show one full sheet depending on the value of one cell?
Thank you, very helpfull content!
Tnk very much. This is useful for my work
thank you very much.. it's very helpful
Glad it was helpful!
EXCELENTE EXPLICACION
thank you very very much .. you are the best
You're welcome!
loooooove u thank u
Can you add code to have array of shape names and use that list to hide and unhide? Thanks
As part of my thanks with your tutorial I able to create amazing code vba for hiding objects here is my code I've learned💓💓
Sub wohooo()
Dim A1, B1, C2 As String
A1 = range("M3").Value
B2 = range("N3").Value
For r = A1 To B1
C1 = "Picture" & " " & r
Activesheet.shapes(r).visible = Not ActiveSheet.Shapes(r).Visible
Next
End Sub
I'm so thankful 💓💓💓💓 finally I can now hide those objects in excel
That is awesome!
Thanks for theses videos. This is what I have been searching for. However, is there a way to hide the developer table, copying options on files located on a desktop with vba?
I'm not sure if I understand your question. Can you clarify?
what if the object is an object? Like an image you just pasted into the sheet? I find sometimes if you insert it as a picture, the image shows up blurry, as opposed to just pasting it there. It's name then appears as 'object #'. How do I manipulate that using 'ActiveSheet' in VBA?
How can you hide shapes based on a specific cell value. I have a worksheet that i want to hide shapes based on Yes Or no answers in a specific cell
Thankk you so much💓💓💓💓💓💓💓. No I will try to apply the dim features with this so this can automatically hide pictures objects in my excel. 💓💓 Thank you so much for this super amazing information
You are welcome 😊
How can I hide a command prompt window ( that black one)? Thanks in advance!
Thank You.
How can i remove or hide shape from copied sheet after create copy for master one
How to hide an activeshape? For instance, there are 100 shapes in the active window, and I want to hide the selected shape? For example my friend clicked the shape, and now my task is to hide that shape. How can I hide it automatically w/out the need of knowing its name? Is there a word or code ActiveShape as like as ActiveCell?
One thing I have done to hide multiple items at the same time is to group all the items together and hide that group instead of the individual items. I may do a video on how to do this.
I'm totally puzzled on how to hide shapes that are not hidden when rows are hid.
It is so annoying how excel not shapes when rows of that shape are hidden. It still shows.
I would make a conditional that says if the row is hidden to hide "X" object. That's likely how I would handle that.
❤️❤️