Macros not supported in Excel 2008

[larsson]

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

 

[calb]

As far as I'm aware, you can only hide/show rows manually. Excel 2011 will bring support back.

 

[larsson]

As far as I'm aware, you can only hide/show rows manually. Excel 2010 will bring support back.

Thanks, but it looks as if Office 2010 is only for Windows (judging by Microsoft site).

 

[steveoc]

The new MS Office for Macs will be deemed 2011. It is my understanding that it is slated for release late 2010.

 

[exegete77]

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.

 

[calb]

Thanks, but it looks as if Office 2010 is only for Windows (judging by Microsoft site).

Sorry, I meant 2011. It should be out later this year, as someone has rightly corrected me.

 

[sbhoso]

macros

Please let m eknow if there is a macro on the Mac to calculate age from DOB
Thanks

 

[GGJstudios]

Please let m eknow if there is a macro on the Mac to calculate age from DOB
Thanks

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