Unable to open correctly Excel 2007 Macro Enabled Sheet on Excel 2010

Unanswered Unable to open correctly Excel 2007 Macro Enabled Sheet on Excel 2010

  • Thursday, November 18, 2010 6:01 AM
     
     

    A commercial application is available as Excel2007.xlsm file. On 2007 it will ask for Macro enabling and Open it correctly. I have placed the company as TRUSTED in 2010. Yet, when opened, it doesnt enable any macro. It doesnt even prompt for macro enabling.

    Are the file formats and macros fully upward compatable from 2007--> 2010?

    How do I overcome this?

    Thanx.

    • Moved by Jennifer ZhanModerator Friday, November 19, 2010 7:08 AM (From:Office 2007 Planning and Deployment)
    •