Results 1 to 6 of 6

Thread: How to Run Excel 2003 Macros in Excel 2007

  1. #1
    Join Date
    Apr 2010
    Posts
    84

    How to Run Excel 2003 Macros in Excel 2007

    Hello everyone, I am trying to migrate from Excel 2003 to Excel 2007 but none of my Macros do not work on 2007. I do not even have access to the VBA editor by Alt + F11. I tried to add functions "macros" in the tape but it does not activate. Can you tell me how to solve this problem please. Thank you in advance

  2. #2
    Join Date
    Apr 2008
    Posts
    4,642

    Re: How to Run Excel 2003 Macros in Excel 2007

    As far as i know macros are only some pieces of code which can be used for changing the Excel spreadsheet. It is possible to create a Macro using the "Record macro" function in MS-Excel. You can also create an excel macro within the Visual basic if you want to create application in the Visual basic editor. But if you want to copy the macros made in excel 2003 you need to have access to the macro code in the VB Editor for copying the code in Excel 2007. Also there appears a security issue so check thew security level.

  3. #3
    Join Date
    Apr 2010
    Posts
    84

    Re: How to Run Excel 2003 Macros in Excel 2007

    Thanks for the quicck reply but the reply could not solve the problem even though i checked the security, but nothing helped. In Longlet developer all the functions are grayed out that is they are disabled and hence i cannot access them. How to gain access to power and at least VBE macro recorder.

  4. #4
    Join Date
    May 2008
    Posts
    4,570

    Re: How to Run Excel 2003 Macros in Excel 2007

    For this you will need to follow the steps which i have mentioned below
    1. Hold the alt Key and press F11 in Excel 2003 work book where you macros are attached.
    2. To open the Macro code window click on the macro name in the left hand side of the macro name.
    3. Copy the entire code select all pressing Ctrl + A and then Press Ctrl + C
    4. Simply open the VBA Editor in the excel 2007 by clicking Ctrl + f11.
    5. Select Open and click module to open up a new module.
    6. Paste the code by pressing ctrl + V.

  5. #5
    Join Date
    Feb 2008
    Posts
    1,337

    Re: How to Run Excel 2003 Macros in Excel 2007

    Theoretically, if the security level (menu option Office Excel) are good theoretically if you click on the design mode, the buttons should become available (I had this problem too). But i solved this when i clicked on the button in the design mode. So hope fully this should resolve your issue too.

  6. #6
    Join Date
    May 2008
    Posts
    4,345

    Re: How to Run Excel 2003 Macros in Excel 2007

    The macros from the Excel 2003 all almost compatible with the Ms-Excel 2007. To use the macros of the excel 2003 in the excel 2007 you will have to copy the macros from the excel 2003 work book and then paste the Macros in the Excel 2007 workbook. It will definitely work.

Similar Threads

  1. Excel 2003 Macro doesn't work in Excel 2007
    By jjaw in forum Windows Software
    Replies: 3
    Last Post: 03-01-2014, 03:28 PM
  2. Excel 2007 macros have disappeared
    By LakshanA in forum Windows Software
    Replies: 4
    Last Post: 09-11-2010, 09:13 AM
  3. Hiding rows in Excel 2007 using macros
    By sam007 in forum Windows Software
    Replies: 3
    Last Post: 16-10-2009, 01:57 PM
  4. 2007 Excel Headache: Macros
    By DHR in forum Windows Software
    Replies: 4
    Last Post: 28-04-2009, 06:18 AM
  5. Excel 2003 VBA to Excel 2007 VBA help needed.
    By JasonM in forum Windows Software
    Replies: 3
    Last Post: 29-01-2009, 11:51 PM

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
  •  
Page generated in 1,711,612,884.24013 seconds with 17 queries