Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2009 on Windows XP.
I have trouble opening an xls file. When I try to open the file eihter from folder or from FILE menu of MS Excel, I get Microsoft Security Alert message box which prompts me to Enable or Disable Macros. I tried both options but still unable to open this file. Please note that, by alt+F11, i noticed that my file has macros. When i tried to open the file in macros explorer i was prompted for a password. Needs your help if anybody encountered a similar situation. -- Atif |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Try going to Developer , Macro Security (located in the code section) macro settings, check "Trust access to the VBA project object model", hope this help "MAtif" wrote: Excel 2009 on Windows XP. I have trouble opening an xls file. When I try to open the file eihter from folder or from FILE menu of MS Excel, I get Microsoft Security Alert message box which prompts me to Enable or Disable Macros. I tried both options but still unable to open this file. Please note that, by alt+F11, i noticed that my file has macros. When i tried to open the file in macros explorer i was prompted for a password. Needs your help if anybody encountered a similar situation. -- Atif |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
No, it didn't solve my problem
-- Atif "Eduardo" wrote: Hi, Try going to Developer , Macro Security (located in the code section) macro settings, check "Trust access to the VBA project object model", hope this help "MAtif" wrote: Excel 2009 on Windows XP. I have trouble opening an xls file. When I try to open the file eihter from folder or from FILE menu of MS Excel, I get Microsoft Security Alert message box which prompts me to Enable or Disable Macros. I tried both options but still unable to open this file. Please note that, by alt+F11, i noticed that my file has macros. When i tried to open the file in macros explorer i was prompted for a password. Needs your help if anybody encountered a similar situation. -- Atif |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable macros on a programmatically opening .xls file | Excel Discussion (Misc queries) | |||
Opening a file with macros lead Excel to crash | Excel Discussion (Misc queries) | |||
Macros Disabled when opening file | Excel Discussion (Misc queries) | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Trouble opening an Excel file that contains macros | Excel Worksheet Functions |