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

    I have a process which has taken me 25 steps to complete.
    For each step I created a separate VBA routine, and assigned each to a button (a 'Form' button NOT a 'Control' button).
    (These routines are importing datafiles, processing, creating pivot tables, extracting data blah blah blah)

    I now wanted to link all my steps together, as a single routine, effectively calling each of my 25 routines.
    Being lazy, for situations like this I usually turn the macro recorder on, select each of my relevant sheets and merrily click the buttons in the required sequence order.
    Then I would tidy up the recorded routine etc.

    Well, it seems the macro recorder in Excel2010 doesn't like to record the clicking of a button any more.
    Is it just me?
    Has anyone else noticed?

    zeddy

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Which version are you using - the 32-bit or the 64-bit? As I understand it, very little was changed in the VBA processes, but some additional functions were added to the macro recorder. In effect what you are doing is trying to record a macro to run a macro, which it seems should work.
    Wendell

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Wendell

    Yes, you are right - I am trying to record a macro to run a sequence of macros.
    Did this many times in earlier versions.

    I am using 32-bit Excel 2010 (version 14.0.4760.1000)

    Perhaps it's something to do with Trust settings?

    zeddy

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I have a feeling that this was disabled in 2007.
    It certainly does not appear to work in 2007 or 2010.
    Andrew

Posting Permissions

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