Share via

Macro function in Excel 2010 disabled.

Anonymous
2010-07-21T05:53:06+00:00

I can see MACROS in both, the VIEW and the DEVELOPER (here CODE) tab, but in both its not activated. I tried Options and Settings but it will not be activated. The functions I can use are USE RELATIVE REFERENCES and MACRO SECURITY. How to activate record macros, macros and visual basic in Excel 2010 (Beta)?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-01-31T05:03:19+00:00

    Go to start, run

    Type appwiz.cpl and click ok

    Select microsoft office 2010 and click change

    Select add or remove features and click continue

    Expand office shared features

    Select visual basic for applications

    Select run from my computer and click continue

    Finish setup and test again to see if macro functions enabled

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2014-07-03T18:15:40+00:00

    THE BEST!!!

    WORKED PERFECTLY!

    I couldn't create any macro because always pop up the error saying the name of macro wasn't correct.

    Now I can create as many macros as I want!!

    Thank you sooooo much!!!

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2012-08-12T02:09:57+00:00

    USELESS

    0 comments
  4. Anonymous
    2010-07-21T14:20:48+00:00

    Did you save as a Macro Enabled workbook?

    1. Click the Office button and then click Save As.

        The Save As dialog box appears.

    1. Enter a name and select a location for your workbook.
    2. Click the Save as Type drop-down arrow.

        A list of file types appears.

    1. Select Excel Macro-Enabled Workbook (*.xlsm).

        Excel adds the .xlsm extension to the filename.

    1. Click Save.

    Read more: http://www.dummies.com/how-to/content/saving-and-using-an-excel-2007-macroenabled-workbo.html

    Trevor Lowing, PMP http://officetechsupport.wordpress.com/

    0 comments