Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 3rd 06, 11:54 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 1
Default Protect Sheet but allow sorting

Don't tell me I have to be a prorammer to protect my sheet but allow
for sorting!!! That will kill me and take days.

I have a workbook with 2 worksheets (tabs) that I would like to protect
from editing, but would like to allow for sorting.

HELP...


  #2   Report Post  
Old November 4th 06, 12:00 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Protect Sheet but allow sorting

Debra Dalgleish has a technique that sorts a range by a certain column by
clicking on an invisible rectangle in the header.

You could add a couple of lines to that code--a line to unprotect the worksheet
near the top and a line to protect the worksheet when it's done (right near the
bottom).

http://contextures.com/xlSort02.html

LucyK wrote:

Don't tell me I have to be a prorammer to protect my sheet but allow
for sorting!!! That will kill me and take days.

I have a workbook with 2 worksheets (tabs) that I would like to protect
from editing, but would like to allow for sorting.

HELP...


--

Dave Peterson
  #3   Report Post  
Old November 4th 06, 12:18 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default Protect Sheet but allow sorting

If you are using XL2002 or better then when you protect the sheet there is a
set of options specifying what the user is and is not allowed to do. Sort is
one of the options. Otherwise you are stuck with Code. One thing you can do
in code relatively easily is to unprotect the sheet if the cursor is within a
specific group of cells. By doing this if the user is in the header row then
you unprotect allowing the sort. otherwise if they are anywhere else then the
sheet is protected. If that appeals to you then let me know...
--
HTH...

Jim Thomlinson


"LucyK" wrote:

Don't tell me I have to be a prorammer to protect my sheet but allow
for sorting!!! That will kill me and take days.

I have a workbook with 2 worksheets (tabs) that I would like to protect
from editing, but would like to allow for sorting.

HELP...


  #4   Report Post  
Old November 12th 06, 08:13 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 1
Default Protect Sheet but allow sorting

I am using Excel 2003 and I am having similar problems protecting a sheet
from editing while allowing sorting.

I have protected the sheet with the "sort" option switched on. If I do not
do this, the "sort" option in the "tools" menu would be greyed out and
unselectable. However, even with the option switched on so that the sorting
option is at least selectable, I STILL get an excel warning that the
worksheet is read-only and that I should unprotect the worksheet to sort it
?!!

Help please!
  #5   Report Post  
Old December 20th 06, 11:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 5
Default Protect Sheet but allow sorting

I too am having problems with protecting an Excel 2003 spreadsheet from
changes but allowing users to sort. I click ToolsProtectionProtect Sheet
and put a check mark in the Sort box of "Allow users to..." (as the
documentation specifies). Nevertheless, subsequently trying to use DataSort
or the Sort buttons produces an error message.

Has anyone out there been able to make it work? How?
--
George M


"LucyK" wrote:

Don't tell me I have to be a prorammer to protect my sheet but allow
for sorting!!! That will kill me and take days.

I have a workbook with 2 worksheets (tabs) that I would like to protect
from editing, but would like to allow for sorting.

HELP...




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect Workbook Vs Protect Sheet Poor_pakistani New Users to Excel 4 May 25th 06 02:06 PM
Problem created by sorting linked sheet Becks Excel Discussion (Misc queries) 2 May 2nd 06 12:28 PM
how do I protect formula's only, not entire sheet or book? Beginner Excel User Setting up and Configuration of Excel 2 February 16th 06 09:07 PM
Protect Data, but allow sorting Pete Walburn Excel Discussion (Misc queries) 4 November 30th 05 08:33 AM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM


All times are GMT +1. The time now is 01:17 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017