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.
Bookmarks