Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
EdS EdS is offline
external usenet poster
 
Posts: 1
Default Opening Excel2003 files w/macros in 2007 - how?

I have 2007 installed and cannot open a 2003 file with macros - file opens
but macros are disabled. How do I turn off the macro disabled security
function in Excel2007??
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 18
Default Opening Excel2003 files w/macros in 2007 - how?

Hi,

Click the Office button.

Click "Excel Options" button.

Select "Trust Center".

Click "Trust Center Settings ..." button.

Select "Macro Settings".

If the Radio button is set to "Disable all macros without notification"
change it to one of the other settings, preferably ""Disable all macros with
notification".

HTH,

Cheers,

Matt

"EdS" wrote:

I have 2007 installed and cannot open a 2003 file with macros - file opens
but macros are disabled. How do I turn off the macro disabled security
function in Excel2007??

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 stop Excel from opening all files w/macros & running them BobC Excel Discussion (Misc queries) 4 April 5th 09 08:25 PM
Excel 2007 not opening files JohnS Excel Discussion (Misc queries) 2 January 12th 09 03:28 PM
Opening XL 2007 Files Jalal Excel Discussion (Misc queries) 0 March 28th 08 10:48 AM
Opening 2007 files msenior Excel Discussion (Misc queries) 1 January 19th 08 01:04 AM
Auto run of macros immediately after opening the files gane Excel Worksheet Functions 2 October 31st 07 01:41 PM


All times are GMT +1. The time now is 05:22 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"