| 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 |
| 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) | |||
Threaded Mode
