Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

umop2

macrumors newbie
Original poster
Feb 12, 2010
2
0
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.