Link to home
Start Free TrialLog in
Avatar of anuneznyc
anuneznycFlag for United States of America

asked on

Is There a Way to Create Macros in Excel 2008 for Mac?

I would like to be able to create a one-step keyboard shortcut to change the background color of a cell to yellow in an Excel spreadsheet created in Excel 2008 for Mac.

There is a "Macros..." option under Tools, but it doesn't seem to have any Record option?
SOLUTION
Avatar of iamsapphire
iamsapphire
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Sigurdur Armannsson
Sigurdur Armannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>"Although you cannot record new Excel macros in Excel 2008, you can run and modify them"
where does it say that?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anuneznyc

ASKER

Below  is what I found on the Mac section of the MS site:

Cause:  Office 2008 for Mac cannot run Visual Basic macros or load add-ins that contain Visual Basic macros.

Solution:  Keep the macro in the file.

Solution:  Remove the macro from the file.

Solution:  Save the macro in another macro-enabled file format.

Solution:  Create a new macro by using AppleScript.
I will close now. Sorry for the long delay.
Thanks.