View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default How do I create template with unalterable headings

If I understand you question correctly, you can 'lock' most cells and objects
in excel.

All cells are locked by default in excel, but this is only applied if you
choose to 'protect worksheet' (not workbook, important).

Select the cells or ranges of cells you want to be able to edit, right click
-- format, --- protection. Uncheck 'locked.' Protect your worksheet,
(there's some options there as to what users can do with locked or unlocked
cells) and add a password of your choice.

If objects are not locked by default, I believe you can right click them,
--- format and set protection for them as well.

I hope this was what you were after.

Mike

"Mary Anne Evans" wrote:


--
I wish to create a workbook in Excel some items fixed so that they cannot be
altered, i.e. an invoice where my letterheading can be inserted but not
altered by others, and the footer with my address ditto. I am using Office
Professional 2007on Windows Vista.

Mary Anne Evans, Assured Transcription