+ Reply to Thread
Results 1 to 12 of 12

Can't press "Record macro"

  1. 06-14-2009, 10:26 AM #1
    westgren
    westgren is offline
    Registered User
    Join Date
    06-14-2009
    Location
    Jönköping, Sweden
    MS-Off Ver
    Excel 2007 Student/Home
    Posts
    4

    Can't press "Record macro"

    Hi,

    I have a quite critical problem trying to start create a macro. I can't even press the record buttom, its just gray. The same is with a couple of other buttons like "visual basic", "Design" and "Macros" etc. Any idea what can be wrong? Do I need to download something before i get started? i'm using the student and home edition of excel 2007
    Reply With QuoteRegister To Reply
  2. 06-14-2009, 10:35 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Can't press "Record macro"

    You need to make sure that the Developer tab is available

    http://office.microsoft.com/en-gb/ex...730521033.aspx
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 06-14-2009, 10:37 AM #3
    westgren
    westgren is offline
    Registered User
    Join Date
    06-14-2009
    Location
    Jönköping, Sweden
    MS-Off Ver
    Excel 2007 Student/Home
    Posts
    4

    Re: Can't press "Record macro"

    How can i not press them if i don't have them?

    I have that menu but i can't press several of the buttons
    Reply With QuoteRegister To Reply
  4. 06-14-2009, 11:23 AM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Can't press "Record macro"

    i'm using the student and home edition of excel 2007
    If that's your usual version, would you please change your profile to agree?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  5. 06-14-2009, 11:27 AM #5
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Can't press "Record macro"

    Quote Originally Posted by westgren View Post
    How can i not press them if i don't have them?

    I have that menu but i can't press several of the buttons
    Read the article that I gave you a link to - you need the Developer Tab enabled.
    Reply With QuoteRegister To Reply
  6. 06-14-2009, 11:27 AM #6
    westgren
    westgren is offline
    Registered User
    Join Date
    06-14-2009
    Location
    Jönköping, Sweden
    MS-Off Ver
    Excel 2007 Student/Home
    Posts
    4

    Re: Can't press "Record macro"

    editeditedit
    Last edited by westgren; 06-14-2009 at 11:45 AM.
    Reply With QuoteRegister To Reply
  7. 06-14-2009, 11:31 AM #7
    westgren
    westgren is offline
    Registered User
    Join Date
    06-14-2009
    Location
    Jönköping, Sweden
    MS-Off Ver
    Excel 2007 Student/Home
    Posts
    4

    Re: Can't press "Record macro"

    royUK

    I don't know if i'm not clear enough, I have the menubar (!) but i can't press the buttons on it

    I attach a screenshot if it still isn't clear.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  8. 06-14-2009, 12:30 PM #8
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Can't press "Record macro"

    If there any code already in the workbook?

    Is your PC administered?
    Reply With QuoteRegister To Reply
  9. 06-14-2009, 12:52 PM #9
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Can't press "Record macro"

    Try re-installing from the CD, choose Repair
    Reply With QuoteRegister To Reply
  10. 01-26-2019, 09:13 AM #10
    Hadoz9
    Hadoz9 is offline
    Registered User
    Join Date
    01-26-2019
    Location
    Czech republic
    MS-Off Ver
    newest - online
    Posts
    3

    Re: Can't press "Record macro"

    Hi

    I had similar problem. Just close the Microsoft Visual Basic Window when you want to Record Macro

    Hope it will work
    Reply With QuoteRegister To Reply
  11. 01-26-2019, 10:30 AM #11
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Can't press "Record macro"

    Probably. But the thread being 10 years old, I hop the OP already solved it...
    Reply With QuoteRegister To Reply
  12. 10-09-2019, 03:38 PM #12
    sixtyfourbit
    sixtyfourbit is offline
    Registered User
    Join Date
    10-09-2019
    Location
    Maryland, USA
    MS-Off Ver
    365 ProPlus
    Posts
    1

    Re: Can't press "Record macro"

    yes it worked. Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1