Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

Daendre has attended:
Upgrade to Office 2007 course

Excel 07

Are there any new macro features?

RE: Excel 07

Hi Daendre

Thank you for your question and welcome to the forum.

To my knowledge, macros are pretty much the same from the 2003 to the 2007 version in terms of recording and running them.

You need to display the Developer ribbon to be able to record and run macros (as used to be done using the Tools menu in previous versions). To do this go to the Office button, Excel Options and in Popular tick the Show Developer tab in the ribbon option and click OK.

According to the following article, macros that have been written in code using the 2003 version should work ok in the 2007 version:
http://www.directionsonmicrosoft.com/sample/DOMIS/update/2006/06jun/0606ccmto2.htm

I hope this helps.

Kind regards
Amanda

Wed 18 Feb 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Microsoft Office tip:

Full Menu Display (Office 2003-2000)

One of the developments in Microsoft Office is that the Menu system has been optimized. This means that only recently used functions are displayed initially when you SINGLE CLICK on the menu.
There are many ways of getting around this:
1. DOUBLE CLICK on the menu bar, it will automatically expand
2. click on the DOUBLE ARROW you see on the bottom of the menu.
3. Wait for the menu to expand

If you always want to have the menus expanded:
4. On the menu bar, click TOOLS, then CUSTOMISE. Select OPTIONS, then uncheck the

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.