Results 1 to 4 of 4
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 481 Times in 458 Posts
    Hi

    I have a wordart shape which contains text e.g. "Sales Europe".
    I want to change this via VBA to say, "Sales China"

    In Excel2010, when I directly right-click on the wordart shape, the "Edit Text" menu option is greyed out i.e. unavailable.
    If I open the file in Excel2007, I can right-click on the wordart shape and the "Edit Text" menu option IS available.

    I know I can also edit the wordart text directly in Excel2003 etc.

    So, why can't I do it in Excel2010???????

    I have assigned a name to the shape, but that hasn't changed in my versions for Excel2003 or Excel2007.

    I'm puzzled.

    zeddy

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Are you using the final release version of Excel, or the Beta version? If it's the Beta version, it may well be fixed in the final release. If you are using the final release, then you may well have found a bug.
    Wendell

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 481 Times in 458 Posts
    My office computer has the final release.
    My home computer has the beta.
    I'm at home.
    My office is 300 miles away.
    Guess I'll have to wait.

    zeddy

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 481 Times in 458 Posts
    Quote Originally Posted by WendellB View Post
    Are you using the final release version of Excel, or the Beta version? If it's the Beta version, it may well be fixed in the final release. If you are using the final release, then you may well have found a bug.
    I have now tested it on the release version 14.0.4760.1000 and it now works as expected.

    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •