Wednesday, August 7, 2013

Macros in excel 2007 for web adi(Oracle E-Business Suite)


 Excel 2007:

  • Open Start button and select Microsoft Office Excel 2007
  • Click the Office Button (top-left button in the window) 
  • Click the 'Excel Options' button.
  • Click 'Trust Center' link from the menu on the left.
  • Click 'Trust Center Settings' button.
  • In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
  • Under 'Macro Settings' check ‘Enable all Macros(not recommended; potentially dangerous…’).
  • Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
  • Click 'OK' button to close the 'Trust Center' window.

No comments:

Post a Comment