Single Image Selection / Shortcut Key (Mac Excel 2011)

[chendric3]

Single Image Selection / Shortcut Key (Mac Excel 2011)

Hi -

I’m using Excel for Mac 2011.

I wrote a macro to scale, rotate, cut, and paste the image that I drag and drop from the finder:

Sub rotatescale2()
'
' rotatescale2 Macro
'
' Keyboard Shortcut: Option+Cmd+y
'
Selection.ShapeRange.IncrementRotation 90
Selection.ShapeRange.Height = 54
Selection.Cut
ActiveSheet.Paste
End Sub


If I select ONE image that I have dragged and dropped onto my worksheet, pressing ‘Option+Cmd+y’ does NOTHING.

If I select more than one image that I have dragged and dropped onto my worksheet, pressing ‘Option+Cmd+y’ runs the rotatescale2 macro properly.

If I manually run the macro on one selected image, it functions properly.

I have tried multiple shortcut keys without any success.

Can you tell me how to get my macro to work on a SINGLE SELECTED IMAGE?

Thanks so much!

Charles