1. S

    Moving a shape without explicitely naming the shape

    Hello, Using the moderator, from this site (Fluff)'s help a couple days ago, a sequence of code was developed that showed when clicking on a cell the name of any shape that was currently located directly within that cell or astride of its borders. That worked great thanks to Fluff. But the...
  2. R

    Updating Objects in Different Groups in the One Worksheet

    I have a worksheet where a map has been created using a number of freeform objects. Each of these objects has been assigned the name of the territory which it represents. I then have a list of each territory, with a reference to the fill colour required. I have this working with the first...
  3. S

    Filled shapes becomes transparent when changing sheet through VBA

    Hi, I've tried to utilize VBA to enable smooth transitions between sheets. When activated a square shape is moved into cell A1 and gradually fills the screen before the sheet is changed. On the next sheet a similar shape is gradually becoming transparent (and later moved out of sight) to...
  4. H

    Convert group of shapes to picture

    Hi, I'm working an a project where I try to convert a group of shapes to a picture and then delete the group. Shortly how I done so far: (the s_text, s_header etc. are programmatically generated shapes) Dim shpGroup As Shape Set shpGroup = sales_sheet.Shapes.Range(Array(s_text.Name...
  5. Worf

    VBA – Transferring picture to worksheet pixel by pixel

    Say that you want to analyze the color distribution of a given picture. One way to do this is to have each worksheet cell representing one image pixel. To use the code, run the transfer routine, specifying the sheet and the shape name. #If VBA7 Then Public Declare PtrSafe Sub Sleep Lib...
  6. M

    Resizing textbox based on the table height next to it.

    Hi I have a few tables and a few textboxes next to the tables. I want the textboxes to expand when new rows are added to the table. The range would be dynamic hence I have to find the textbox in the specified range and then adjust the height. I tried to code it but the height of the textbox...
  7. R

    Issue with Text in Shapes

    Hello, For some reason whenever I open up my workbook, the text in my shapes has automatically moved to the back so that it appears like there is no text in the shapes. So every time I re-open the workbook, the first thing I have to do is click on a shape and send the text to the front. This...
  8. Worf

    Manipulating shapes with VBA

    Here is a description of this application: Canvas sheet - shows your current work. Problem sheet - presents the original problem and also some examples that can be pasted on Dat page. Dat sheet - There are stored triangles vertices generated by the program. Alternatively, you can insert your...
  9. M

    After change from Picture.Insert to Shape.AddPicture picture image is shifted

    Hi, Hi I had to modify excel template VBA code to make image logo persistent outside the network so I change simple Picture.Insert(pfile) to: Set vOldShape = vSheet.Shapes(pName) If Not vOldShape Is Nothing Then vLeft = vOldShape.Left vTop = vOldShape.Top...
  10. P

    VBA to check if circles are inside of freeform area or not

    Hi, Im newbie on this site and I need help with this : I have Freeform area and shapes in form of circles named from A to G. Some of this points are inside of Freeform area and some of them no. I need macro which will check each of this points if this point is inside/ outside of freeform area...
  11. G

    Help with vba to scroll group of shapes

    Hi everyone, I have shapes in my worksheets, these shapes have been grouped, i am trying to get these groups to scroll down as the user scrolls down the worksheet. Below is the code i am using, my problem is that it keeps bugging at line Set myGroup. is there something wrong here that i can...
  12. N

    Enable / Disable Shapes

    Hi All, I have a excel template where I have 8 shapes created as button and assigned a macro to each shape. Is there a option to disable the Shapes where the users are unable to click the shapes to run the macro. For example: I have a shapes with names Login and Logout. When the excel is...
  13. A

    Deleting Lines and Rectangles

    Hi, I have a need to delete many shapes on a worksheet although I wish to keep others. All of the shapes that I wish to delete are either lines or rectangles and the ones that I wish to keep are not. I had hoped the following would work, but it doess not - can anybody let me know what the...
  14. G

    Freeze a shape

    Is there a way to freeze a shape so that it behaves like freezing cells? I want to freeze a shape so that it always stays on the screen even when a user scrolls.
  15. M

    How to change visio shape text based on worksheet row content using for each loop?

    I created this for each loop to add the devices ip address to the shapes text it find the devices if i put a static name on the code but It doesn't look like is reading the worksheet names from column A When I change the loop and write one of the shapes name on it I'm able to change any of the...
  16. F

    VBA With statement: How to copy grouped items?

    Hi, I have previously created a chart and copied it to another sheet. But now I have added a text box and grouped the text box and chart together (not in VBA). I want to be able to copy the group to another sheet as a picture. I believe instead of "Chart" it's "Shape" in VBA. But I don't know...
  17. J

    default to not move or size shapes?

    Is there a way, like creating a template, that will default to"do not move or size" shapes"?
  18. D

    VBA to cycle through values to change colours of various shapes

    Hello there, I have a range of shape names followed by various values which correspond to the colours which I'd like to assign. I'm having problems piecing together the VBA code in order to update the shapes in one go. My data source is on the sheet named "Data" with the shapes on one called...
  19. D

    Deactivate connectors from shapes

    Hi all :) Does anyone know a VBA code that would allow me to deactivate connectors from shapes. Here see an example Because what I would like is to turn the shapes at 180 degrees without moving the connectors. That's why I'm...
  20. G

    How to ignore Overlapping shapes with VBA code

    The code as is works in most situations however sometimes when a bar slightly over laps it will count in the range and sometimes I can't get it out of the range. This code is going into a document that I don't use it's used by other people who produce a schedule and for whatever reason they have...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back