Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
SS SS is offline
external usenet poster
 
Posts: 32
Default How to enable Macros in excel 2007

Hi,

Yesterday, in one of our deparments, we have installed Office 2007.
Users are using some files created in Excel 2003. These files uses some
macros created in that version it self. So, when they are trying to open
these files in Excel 2007, it is araising them Security message. Macros have
been disabled.
I tried to enable the macros for them by going in Macro settings and
selecting the 'Enable all macros radio button'. But, this is not working for
them. when they try to open the form again, it is just showing the Excel
console. It is not showing any thing else.
when I did see in the even viewer , it is giving me the following error with
EventID1000.

Faulting application excel.exe, version 12.0.4518.1014, stamp 45428263,
faulting module excel.exe, version 12.0.4518.1014, stamp 45428263, debug? 0,
fault address 0x00c46b99.

any help in this regard is greately appreciated.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 533
Default How to enable Macros in excel 2007

If the workbook or its structure is password protected you are probably
running into this issue:

http://www.rondebruin.nl/password2007.htm

--
Jim
"ss" wrote in message
...
| Hi,
|
| Yesterday, in one of our deparments, we have installed Office 2007.
| Users are using some files created in Excel 2003. These files uses some
| macros created in that version it self. So, when they are trying to open
| these files in Excel 2007, it is araising them Security message. Macros
have
| been disabled.
| I tried to enable the macros for them by going in Macro settings and
| selecting the 'Enable all macros radio button'. But, this is not working
for
| them. when they try to open the form again, it is just showing the Excel
| console. It is not showing any thing else.
| when I did see in the even viewer , it is giving me the following error
with
| EventID1000.
|
| Faulting application excel.exe, version 12.0.4518.1014, stamp 45428263,
| faulting module excel.exe, version 12.0.4518.1014, stamp 45428263, debug?
0,
| fault address 0x00c46b99.
|
| any help in this regard is greately appreciated.
|
| Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I enable macros in a 1997-2003 spreadsheet in Excel 2007 Glen Excel Discussion (Misc queries) 4 October 3rd 07 11:03 PM
Simple way to enable just my personal macros in Excel (& Office) 2007 LurfysMa New Users to Excel 13 June 12th 07 12:55 PM
Enable macros in 2007 Anita Excel Discussion (Misc queries) 5 February 10th 07 04:24 PM
How do I stop Excel from prompting to enable or disable macros? ARSmythe Excel Discussion (Misc queries) 4 January 12th 05 01:07 PM


All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"