View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
seanymac seanymac is offline
external usenet poster
 
Posts: 2
Default Workbook_Open not executing in Excel 2007

Hello Excel gurus,

I'm hopeful you can help me figure out why Excel 2007 is not executing
Workbook_Open code. I originally developed this app in Excel 2003
as .xls. I recently have converted to Excel 2007 and saved the app
as .xlsm. I have placed the app in a Trusted Location and set macro
security to "disable all macros with notification" for all documents
not in a trusted location. This works on one computer (XP, SP2, Excel
2007) but not on another with the same config (XP, SP2, Excel 2007).

When I open the app no Workbook_Open code is executed and F5 from VB
Editor says "macros are not enabled."

Any thoughts? What am I missing?

Thanks,
SMc