+ Reply to Thread
Results 1 to 2 of 2

Sort Cells in Password Protected Document

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    6

    Sort Cells in Password Protected Document

    Hello,

    I need to password protect a workbook so data cannot be edited. But, I also need users to be able to sort the data while the document is password protected. I've tried locking the cells in Format Cells and checking the box for Sort when I password protect the workbook, but I still can't sort. Any ideas?

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Sort Cells in Password Protected Document

    After some Web search, I think there is only one way to solve your issue. It is to run a small macro like this one:
    Please Login or Register  to view this content.
    In this command, it is important to set the Contents to FALSE because this is what prevent sorting of your sheet.
    You can add or substact any specific properties you need for your application.
    This macro can be run as the sheet is activated events or as workbook is opened.
    Hope this helps
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro that inputs the password on a password protected document
    By dandavis1 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-09-2014, 10:12 AM
  2. Excel 2007 : Password Protected document
    By usaf_kirby in forum Excel General
    Replies: 2
    Last Post: 09-23-2010, 02:04 PM
  3. modify password protected xls document
    By briana banks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2008, 04:38 AM
  4. PASSWORD PROTECTED DOCUMENT
    By Tom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2005, 11:05 AM
  5. [SOLVED] Linking to a Password Protected Document in Excel 2000
    By Andrew in forum Excel General
    Replies: 2
    Last Post: 02-14-2005, 10:06 PM

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