VBA: Object Required

[excelos]

Hello

I get the error Object Required when I run the following (after having selected few shapes in my xlsx):

Sub ResizeSelectedObjects()
Dim firstObject As Shape
Dim i As Integer

' Get the first selected object
Set firstObject = Selection.ShapeRange(1)

Any idea?

Thanks!

 

[6StringJazzer]

This code runs without error for me. What worksheet contains the shapes, what module is the code in, and what worksheet is active when the code runs?

 

[NdNoviceHlp]

Hi excelos. .xlsx files can't run macros? Dave

 

[6StringJazzer]

I'm sure excelos is using that generically to mean "Excel workbook."