| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking column headers
Hi all,
I need to lock the header columns of a spresadsheet/database and so that they cannot be altered (resized or deleted etc) I know I can do that by locking the range and then protecting the worksheet. But if someone else wants to sort the worksheet by any column then it has to be unprotected. Is there a work around so that the column headers can be locked without protecting the worksheet? Any help would be appreciated. Fatwilly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking Formula - Whole Column | Excel Discussion (Misc queries) | |||
| Locking a Column | Excel Discussion (Misc queries) | |||
| make column values column headers | Excel Discussion (Misc queries) | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| Locking column entries to an adjacent linked column | Excel Discussion (Misc queries) | |||
Threaded Mode
