Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() -- 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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create column headings at top of every sheet? | Excel Worksheet Functions | |||
Is it possible to change a template column headings? If so how? | Excel Worksheet Functions | |||
help! how do i create a table with fixed headings?? | Excel Discussion (Misc queries) | |||
Unalterable Random Number | Excel Discussion (Misc queries) | |||
How do I create ccolumn headings diagonally? | Excel Worksheet Functions |