Macros not supported in Excel 2008

Discussion in 'Mac Apps and Mac App Store' started by larsson, May 19, 2010.

  1. larsson macrumors newbie

    Joined:
    May 19, 2010
    #1
    Hello. In moving to Excel 2008 for Mac, I discovered that the ability to use macros was no longer supported. This is a major problem for me, because I have developed applications in which I need to hide specific rows under certain conditions. In the last version, a colleague wrote some macros that did this elegantly. I can't go back to the previous version because of some other constraints. Is there a way to hide rows in the new Excel?
    Thanks
    Nils Larsson
     
  2. calb macrumors 6502

    Joined:
    Mar 12, 2009
    Location:
    UK
    #2
    As far as I'm aware, you can only hide/show rows manually. Excel 2011 will bring support back.
     
  3. larsson thread starter macrumors newbie

    Joined:
    May 19, 2010
    #3
    Thanks, but it looks as if Office 2010 is only for Windows (judging by Microsoft site).
     
  4. steveoc macrumors regular

    Joined:
    Nov 6, 2007
    Location:
    Adirondacks NY
    #4
    The new MS Office for Macs will be deemed 2011. It is my understanding that it is slated for release late 2010.
     
  5. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #5
    If you will only need it for use on the Mac, then you should be able to program Excel using AppleScript.

    On the other hand, if your skills are up to it, you might be able to program cross-platform solutions using Python.
     
  6. calb macrumors 6502

    Joined:
    Mar 12, 2009
    Location:
    UK
    #6
    Sorry, I meant 2011. It should be out later this year, as someone has rightly corrected me.
     
  7. sbhoso macrumors newbie

    Joined:
    Jun 22, 2010
    #7
    macros

    Please let m eknow if there is a macro on the Mac to calculate age from DOB
    Thanks
     
  8. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #8
    You don't need a macro for that. A simple formula will do that:

    Assuming birthdate is in cell B1 (mm/dd/yy)
    =YEAR(TODAY())-YEAR(B1) will show age
     

Share This Page