Excel and Applescript

[umop2]

Hi all,

I am trying to sort a protected sheet, as I do not want people editing the formulas in it.
I need to sort from A8:U150 in ascending order.
The sheet as mentioned has to be unlocked, then locked again after the sort.
It needs to work from some sort of button.

Is this possible? I can do this for the Windows version with Vb but I am unsure of how to completed this on a Mac as it does not support macros.

Running Mac Excel 2008 (also have 05 installed but 08 is preferred).

Thanks in advance guys and girls.

 

[exegete77]

Have you used Applescript at all? If not, look at this starting point and the references:

Using Applescript with Excel.

Then proceed to this: Intro to Scripting MS Excel.

And this might help you: Applescript Reference Guide for MS Excel