OHSU's Software Forum Forum Index OHSU's Software Forum
Peer support for software.
 
 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 Software Forum.

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!

Excel Add-ins to enable 2003 Macros

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



Joined: 12 Nov 2007
Posts: 6
PostPosted: Tue Mar 11, 2008 4:16 pm    Post subject: Excel Add-ins to enable 2003 Macros Reply with quote
Some macros from Excel 2003 may not work in Excel 2007 unless the Analysis ToolPak is installed. First, temporarily enable all macros to confirm that a digital signature issue is not the problem:

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

When opening the macro worksheet with all macros enabled, Excel may tell you it needs the Analysis ToolPak. Install it by following these steps:

1. Click the Microsoft Office Button , and then click Excel Options.

2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.

3. Click Go.

4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

--Tom
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OHSU's Software Forum 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