Results 1 to 2 of 2

AppleScript - Unprotect, Sort, Protect.

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2010
    Location
    Perth
    MS-Off Ver
    Excel 2007
    Posts
    9

    AppleScript - Unprotect, Sort, Protect.

    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.

    (also http://www.mrexcel.com/forum/showthread.php?t=448237)
    Last edited by UMOP; 02-12-2010 at 11:52 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1