How do I create template with unalterable headings

  • Thread starter Thread starter Mary Anne Evans
  • Start date Start date
M

Mary Anne Evans

--
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

template creates invoice - how to create summary worksheet? 13
How do I create my own fill-in template? 4
Creating a macro using letterhead 1
How do I insert a doc with a footer into another doc with a macro 8
How do create different first page in template w/o losing header? 6
Creating a Letterhead Template 3
How do I save a file as an image file? 1
How do I create a letterhead template with header, footer and sid. 1

Back
Top