How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

I just installed the new version of Excel Mac 2008 version

Resolved Question:

I just installed the new version of Excel:Mac 2008 version 12.1.3 and the macro I wrote in the older version has disappeared and I don't know how to write a new one in this new version. Can you tell me how?
Submitted: 8 years ago.
Category: Mac
Expert:  John D replied 8 years ago.



Unfortunately Excel 2008 no longer supports Visual Basic. VBA has been replaced by Applescript in version 2008 for the Mac. If you try to open a worksheet that has a VBA macro you will be prompted to either leave the macro or remove it, but in both cases it won't run. Here is some more detail about this new feature.


Hope this helps. Let me know if you have any questions.

Customer: replied 8 years ago.
Thanks. While I'm sure you are correct, that sure wasn't the answer I was hoping for! I'm now sorry I've upgraded to 2008. All I want to do is automate a very simple thing: Edit>Delete>Shift cells up. Is there a shortcut for this?
Expert:  John D replied 8 years ago.

Again, Excel 2008 lacks the ability to record AppleScripts, so you will have to write everything from scratch. However, if you are familiar with applescript you can use the Automator workflows to activate actions from the Scripts menu within Excel.


If you have workbooks with macros and if you are already familiar with vba macros your best option is to do what most macro users have chosen to do and that is revert back to Excel 2004.


Hope this helps, and please don't forget to click the green Accept button. Thanks

John D and 2 other Mac Specialists are ready to help you