Run Time Error 424 - Animating your companys logo code.

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.

Hi Andy,

Link to the code http://itknowledgeexchange.techtarge...logo-in-excel/

I got rid of the run time error message on the immediate window. You were right, quotation marks did not copy/paste correctly...!!!!!!!!

I do not have the grow shape , spin shape routines.

I'm new to VBA and apart from the obvisious instructions on the site - i did not add these routines.