Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Office general help » Excel 07

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel 07

Resolved · Low Priority · Version 2007

Reply Thu 5 Feb 2009, 16:48Delegate Daendre said...

Daendre has attended:
Upgrade to Office 2007 course

Excel 07

Are there any new macro features?

For upcoming training course dates see: Pricing & availability

Reply Wed 11 Feb 2009, 12:06Trainer Amanda said...

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.

Microsoft Office articles

· Using Separate Office Programmes Together
· Reasons to consider Microsoft Training
· Ho Ho Ho It's The Office Christmas Quiz
· How To Quadruple Your Investment In IT Training
· Now You Can Meet And Greet Clients Without Leaving Your Desk

Please browse our web site to find out more about
ms office training and other Microsoft training courses.

Microsoft office tip:

Prevent macros from running when you start Applications

Macros are automated programs that can help you speed up your work. They can be embedded in caommands like AutoExec which will make them run as soon as an application like MS Word or MS Access are launched.
Sometimes it is useful to be able to switch off this function, and then can be done by the following method.
Hold down the SHIFT key when you click on the icon to start the program. This will suppress any automated macros.

View all Microsoft Office hints and tips