Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock spreadsheet but can sort
I am working on a template. I'd like to lock my spreadsheet so others who
use this template can't change the formula inside, but I'd like to make the sorting feature available. Is there a way to do this? When I go to Tool Protection Protect Sheet, it also disable the sorting feature in Excel. Any help or advice? Thanks, GU |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock spreadsheet but can sort
What version of xl? my 2003 has a checkbox where you select protect that
allows you to check 'sort' -- -John Please rate when your question is answered to help us and others know what is helpful. "Neon520" wrote: I am working on a template. I'd like to lock my spreadsheet so others who use this template can't change the formula inside, but I'd like to make the sorting feature available. Is there a way to do this? When I go to Tool Protection Protect Sheet, it also disable the sorting feature in Excel. Any help or advice? Thanks, GU |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock spreadsheet but can sort
But you can only sort a contiguous unlocked range of cells so is very limited
Gord Dibben MS Excel MVP On Wed, 12 Dec 2007 13:23:01 -0800, John Bundy (remove) wrote: What version of xl? my 2003 has a checkbox where you select protect that allows you to check 'sort' |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock spreadsheet but can sort
I'm using Excel 2004 for Macintosh. I think it's equivalent to Excel 2003
for PC. Unfortunately, there is no such option for me. Are there any Visual Basic option that I can go about to set this up? It just seems so restricted to set this up in Excel, but that's all we have. Thanks for any help. GU "John Bundy" wrote: What version of xl? my 2003 has a checkbox where you select protect that allows you to check 'sort' -- -John Please rate when your question is answered to help us and others know what is helpful. "Neon520" wrote: I am working on a template. I'd like to lock my spreadsheet so others who use this template can't change the formula inside, but I'd like to make the sorting feature available. Is there a way to do this? When I go to Tool Protection Protect Sheet, it also disable the sorting feature in Excel. Any help or advice? Thanks, GU |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock spreadsheet but can sort
ActiveSheet.Unprotect Password:="justme"
'do your sorting by code ActiveSheet.Protect Password:="justme" Gord Dibben MS Excel MVP On Thu, 13 Dec 2007 15:15:01 -0800, Neon520 wrote: I'm using Excel 2004 for Macintosh. I think it's equivalent to Excel 2003 for PC. Unfortunately, there is no such option for me. Are there any Visual Basic option that I can go about to set this up? It just seems so restricted to set this up in Excel, but that's all we have. Thanks for any help. GU "John Bundy" wrote: What version of xl? my 2003 has a checkbox where you select protect that allows you to check 'sort' -- -John Please rate when your question is answered to help us and others know what is helpful. "Neon520" wrote: I am working on a template. I'd like to lock my spreadsheet so others who use this template can't change the formula inside, but I'd like to make the sorting feature available. Is there a way to do this? When I go to Tool Protection Protect Sheet, it also disable the sorting feature in Excel. Any help or advice? Thanks, GU |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock spreadsheet but can sort
Thanks for everyone's help. I try but it doesn't work.
"Gord Dibben" wrote: ActiveSheet.Unprotect Password:="justme" 'do your sorting by code ActiveSheet.Protect Password:="justme" Gord Dibben MS Excel MVP On Thu, 13 Dec 2007 15:15:01 -0800, Neon520 wrote: I'm using Excel 2004 for Macintosh. I think it's equivalent to Excel 2003 for PC. Unfortunately, there is no such option for me. Are there any Visual Basic option that I can go about to set this up? It just seems so restricted to set this up in Excel, but that's all we have. Thanks for any help. GU "John Bundy" wrote: What version of xl? my 2003 has a checkbox where you select protect that allows you to check 'sort' -- -John Please rate when your question is answered to help us and others know what is helpful. "Neon520" wrote: I am working on a template. I'd like to lock my spreadsheet so others who use this template can't change the formula inside, but I'd like to make the sorting feature available. Is there a way to do this? When I go to Tool Protection Protect Sheet, it also disable the sorting feature in Excel. Any help or advice? Thanks, GU |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock spreadsheet but can sort
"it doesn't work" means what?
No sorting? Post your sorting code. Incorrect sorting? Post your sorting code. Gord On Fri, 14 Dec 2007 10:36:05 -0800, Neon520 wrote: Thanks for everyone's help. I try but it doesn't work. "Gord Dibben" wrote: ActiveSheet.Unprotect Password:="justme" 'do your sorting by code ActiveSheet.Protect Password:="justme" Gord Dibben MS Excel MVP On Thu, 13 Dec 2007 15:15:01 -0800, Neon520 wrote: I'm using Excel 2004 for Macintosh. I think it's equivalent to Excel 2003 for PC. Unfortunately, there is no such option for me. Are there any Visual Basic option that I can go about to set this up? It just seems so restricted to set this up in Excel, but that's all we have. Thanks for any help. GU "John Bundy" wrote: What version of xl? my 2003 has a checkbox where you select protect that allows you to check 'sort' -- -John Please rate when your question is answered to help us and others know what is helpful. "Neon520" wrote: I am working on a template. I'd like to lock my spreadsheet so others who use this template can't change the formula inside, but I'd like to make the sorting feature available. Is there a way to do this? When I go to Tool Protection Protect Sheet, it also disable the sorting feature in Excel. Any help or advice? Thanks, GU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i lock a sort, ie no header row | Excel Discussion (Misc queries) | |||
How to lock calculated data before a sort? | Excel Discussion (Misc queries) | |||
how do you lock a jpg on a spreadsheet that you publish to web? | Excel Discussion (Misc queries) | |||
How do i lock sellected cells in a spreadsheet? | Excel Discussion (Misc queries) | |||
lock spreadsheet by date | Excel Discussion (Misc queries) |