Rotate Picture

  • I have a Picture called "Picture 1" on a worksheet.


    In Excel 97 can I rotate this in a macro in VBA


    If you select the Format Picture option the Rotation part is greyed out


    Re Dave

  • Re: Rotate Picture


    Here is some VAB i have written for you, copy teh code into a module and assign a command button to trigger the code, should be ok.


    Jack


  • Re: Rotate Picture


    Hi Jack


    Tried this but will not rotate,


    I do not get an error and the picture is being selected


    Is it Excel 97 as in Excel XP you get an option to rotate in properties.

  • Re: Rotate Picture


    The option to rotate is also not available in xl2k either.


    You can rotate autoshapes, but if you use a picture as the fill although the shape rotates the picture does not.

    [h4]Cheers
    Andy
    [/h4]

  • Re: Rotate Picture


    I am using Excel xp and the code works ok if the Picture is called 2 ie Picture 2 as in the code you have Picture 1 so you might need to edit that part.


    Your stats say:
    MS Office Version: 2002(XP)
    Op System: Windows XP
    Assumed Experience: Above Average (Know VBA & All of Excel)



    Join Date: 8th October 2004
    Posts: 30


    So i assumed would be ok as you are using excel xp also. Make sure the picture name ie 1 is correct and re try it.I have just re tewsted this code on each click teh picture rotates 90 degrees clockwise

    Code
    1. Sub J_R_RotatePicture()
    2. ' written by: Jack in the UK
    3. ' [url]www.excel-it.com[/url]
    4. ' excel xp
    5. ActiveSheet.Shapes("Picture 1").Select
    6. Selection.ShapeRange.IncrementRotation 90#
    7. End Sub
  • Re: Rotate Picture


    Yes my PC is Excel XP but I am helping a friend who only has Excel 97.


    I did edit the pictue name.


    I assume its an Excel 97 limitation.


    Many thanks


    Re Dave