And don't use "Me" - that's for forms and classes.
As the OP's code is in a sheet class I think "Me" would be appropriate. The
event could be triggered whilst not the activesheet and Me would qualify to
the correct sheet, assuming of course the shape is on that sheet.
Regards,
Peter T
"Nick Hebb" wrote in message
ups.com...
Use IncrementRotation, as in:
ActiveSheet.Shapes("Autoshape 6").IncrementRotation -90#
And don't use "Me" - that's for forms and classes.
----
Nick Hebb
BreezeTree Software
http://www.breezetree.com/article_ex...wcharting1.htm