Re: how to sort in a protected worksheet.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The rectangle floats over that cell (including the dropdown arrow). So you
really never got to the arrow.

Maybe you could resize the rectangle so that it only uses the left half of the
cell.

Lisa wrote:

Hi

I have followed this excellent article for giving users the ability to sort
a protected worksheet,

http://www.contextures.com/xlSort02.html

However, I have a problem in that I have the autofilters saved within the
worksheet, and this piece of code conflicts with them - if I select a drop
down arrow on the filter, it sorts the column as in the macro rather than
giving me the drop down list.

How can I get around this? If I can crack this, I will have made a big
breakthrough in my quest

Thanks in advance

"clm" wrote:

i have a large worksheet with over 500 rows and 50 columns that needs to be
sent out to a large audience. how can I allow the worksheet to be sorted
while it is protected? i have tried protecting only certain columns of data
and tried to sort, but it only allows me to sort only the columns that are
not protected and the data in each row entry isn't "expanded" the sort.
--
/clm

--

Dave Peterson
.

Relevant Pages

  • Re: how to sort in a protected worksheet.
    ... Aha cracked it - with my sheet unprotected, I could right click on the cell ... Maybe you could resize the rectangle so that it only uses the left half ... i have tried protecting only certain columns ... and tried to sort, but it only allows me to sort only the columns that ...
    (microsoft.public.excel.misc)
  • Re: Sorting Protected Worksheet
    ... If there is any LOCKED cell in the range to sort ... Unlocking one of the columns, Protecting and then Sorting on that column, but ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Auto Filter
    ... When I hit the arrow for the ... Those are the sort functions that I am trying to get to work. ... I have been using the Auto Filter ... each cell is actually in that cell rather than being "carried over" from the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sorting Protected Worksheet
    ... If there is any cell in the range to sort, then you'll have to find a different ... Maybe you could provide a macro that would unprotect the worksheet, do the sort, ... Unlocking one of the columns, Protecting and then Sorting on that column, but ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Password Protecting Validation Lists
    ... > is clicked while the cell is locked and worksheet is protected. ... you can still click on the arrow which brings up the list and ...
    (microsoft.public.excel)