| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I give permission for certain functions in excel in locked.
I have locked all of a worksheet, except for a data entry portion. During
the locking proceedure, excel appears to give options for allowing the user permission to use certain functions while the worksheet is locked, such as "sort". However, that is not being allowed. Any ideas? |
|
#2
|
|||
|
|||
|
Hi
you have to unlock all cells which should be sorted as well -- Regards Frank Kabel Frankfurt, Germany tradinoncoffee wrote: I have locked all of a worksheet, except for a data entry portion. During the locking proceedure, excel appears to give options for allowing the user permission to use certain functions while the worksheet is locked, such as "sort". However, that is not being allowed. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| In excel, I seem to be "locked" on a cell and unable to click off. | Excel Discussion (Misc queries) | |||
| Excel file locked for editing by 'my name' ! How do I unlock? | Excel Discussion (Misc queries) | |||
| How do I get to master Excel functions and formulas? | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
