shapes formatting

Hi There, I am trying to solve the problem with coloring the shapes based on time and I am struggling with it for some time so hope someone can help me with this. I have 19 shapes on excel sheet and each is having the name Bankomat_ and then number from 1 to 19. The output should be that...

I created a 3D rectangular shape filled with pale orange color. However, the color of the edge is quite dark. I have changed every color I could find in the property but the dark color persisted. Any way to change the edge color?

good morning, i have been running this code which works well however sometimes there will be times when there might be an over lap. i need it to display both colours or have the border the first colour. Sub ShowHideAreas() Dim sh1 As Worksheet, sh2 As Worksheet, i As Long, j As Long Dim...

Hi all, First timer here, currently I am learning VBA and I am progressing pretty good if I say so myself (with Google of course:P). I want to do the following: I want to be able to select multiple shapes and by clicking a button I want to be able to format the selected shapes. I am currently...

Hi All, I am not sure where to start with this one. I never worked on code where shapes would be involved and I am not sure if there is solution for what I need. Basically I have Master sheet with multiple shapes : arrows, rectangles etc. The number of shapes vary from week to week. What I...