OHSU's Microsoft Migration Forum Index OHSU's Microsoft Migration
Peer support for Office 2007 for PCs and Office 2008 for the Mac
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups    RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Welcome
Welcome to OHSU's Microsoft Migration.

You are currently viewing our boards as a guest, which gives you limited access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, join our community today!

Running Older Macros under Excel 2007

 
Post new topic   Reply to topic    OHSU's Microsoft Migration Forum Index -> Office 2007: Macros
View previous topic :: View next topic  
Author Message
howet



Joined: 12 Nov 2007
Posts: 6
PostPosted: Thu Jan 10, 2008 5:37 pm    Post subject: Running Older Macros under Excel 2007 Reply with quote
Some users have reported problems running their existing macros after upgrading to Excel 2007. According to Microsoft's blog on deprecated features, macros as far back as Excel 2.1 (1989) still work in their original format under Excel 2007:

http://blogs.msdn.com/excel/archive/2006/08/24/718786.aspx

I tested this with a rather complex 10-year-old 4.0 macro and it runs fine when opened, then breaks if the file is saved under Excel 2007. But it should be possible to save Excel 2003 macros under Excel 2007 if the macros were originally created and saved in the Excel 97/2003 file format.

For those having Macro problems, here are a couple suggestions. Try running the macro from the original file used under Excel 2003 without ever saving it in Excel 2007. If that doesn't work, temporarily turn on "Enable All Macros," then open and run the macro to see if there's some odd security issue at play:

Ribbon -> Developer Tab -> Macro Security -> Enable All Macros

If the Developer Tab is not visible, turn it on here:

Office Button -> Excel Options -> Popular -> Show Developer tab in the Ribbon

--Tom Howe
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OHSU's Microsoft Migration Forum Index -> Office 2007: Macros All times are GMT - 7 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Community Chest


Powered by phpBB
Hosted by FreeForums.org