Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2010
    Location
    Texas
    Posts
    54
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Things the VBA Code Generator Won't Record

    Of course when I go looking for them, I can't find any: What are some examples that the VBA code generator won't record from the user interface?

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi ForEachLoop,

    Here' one:
    For a table, you can't record changing a cell's margin's to or from the 'same as table' setting. All that will be recorded are the values for the individual margins - nothing about the 'same as table' setting. Indeed, you can't even test that setting in vba, and you can't change it other than by using SendKeys (which is fairly pointless if you can't test it beforehand).
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. The Following User Says Thank You to macropod For This Useful Post:

    ForEachLoop (2011-05-10)

  4. #3
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,853
    Thanks
    4
    Thanked 259 Times in 239 Posts
    In the older versions of Word, you could visit the Tools > Options and record each of the option settings by showing the screen. Now in Word 2007 and 2010 visiting the options doesn't record a thing.

    In Word 2010, changing a Document Property via the Document Panel records nothing.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  5. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    ForEachLoop (2011-05-10)

Tags for this Thread

Posting Permissions

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