Hi,

I am trying to use Craig Hatmakers "Animating your companys logo" VBA code. However i get the above error when in immediate window and the another error in the workbook code window "sub or function not defined".


I have named the picture "Logo" in a sheet called data.

In the immediate window
[Code]
“Selection.Name = “Logo”
[\code]


in the workbook code window

[Code]
Private Sub Workbook_Open()

Worksheets("Data").Activate
ActiveSheet.Shapes("Logo").LockAspectRatio = False
GrowShape ActiveSheet.Shapes("Logo"), 10
SpinShape ActiveSheet.Shapes("Logo"), 10

End Sub
[\code]


Can anyone help, this is very frustrating.