View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fatwilly Fatwilly is offline
external usenet poster
 
Posts: 3
Default 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