objects

  1. D

    Works in 2003 but not in 2007

    I recorded this macro in Excel 2003 and it works fine: Sub Vertical() ActiveSheet.Unprotect ActiveSheet.Shapes.AddLine(597.75, 57, 597.75, 600#).Select Selection.ShapeRange.Fill.Transparency = 0# Selection.ShapeRange.Line.Weight = 0.75 Selection.ShapeRange.Line.DashStyle...
  2. F

    copy worksheets into new workbook preserving code and objects

    Hallo, I need to copy almost all of the worksheets enclosed in addin workbook in a new workbook as a copy of addin workbook, without the modules and classes, but preserving the code and the object (Image1) included into the originals worksheets. The code enclosed into the worksheet modules of...
  3. D

    Object item deletion conditionally

    Hi, I am writing a VBA code in which I am getting certain records in VBA Object. The object contains around 1500 records (Item). Is there any way that I can delete unwanted Items. For example, there is one field MESSAGE_TYPE in object. This field has value either "E" or "A". I want to...
  4. T

    Copying selections to PowerPoint with VBA

    Hi, I am trying to write a routine (via two comboboxes) that will enable users to select a choice of charts from one of three possible worksheets and have the charts on the selected sheet copied to PowerPoint. My difficulties are these: a. I cannot determine how to pass the selections to Excel...
  5. N

    searching for objects within the sheet

    Is there a way to know whether there are objects (such as picture,pdf file,etc)inserted in a sheet and of what type it is ....?:rofl:

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top