Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a excell document that can be filled out by other pe
I have created a work order for my business and now I want to be able to send
it to my dealers and have them fill in the underlined blanks on the work order. I need to know how do I go about doing this so that all of the document cannot be change that I have done already. But where the blank spots next to the text can be filled into by the other user and can be sent back to me VIA email. Also I am not using outlook as my email program. -- BRANDON |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a excell document that can be filled out by other pe
You can protect cells that you doesn't want users to change as follows :
Highlight those cells by pressing the Ctl key Go to Format on the Menu bar Select Cells Select Protection tab uncheck the Locked, click OK Go to Tool on the Menu bar Select Protection choose Protect Sheet apply your password Does this do what you want? Pls click Yes if this help cheers, "Phantom Menace" wrote: I have created a work order for my business and now I want to be able to send it to my dealers and have them fill in the underlined blanks on the work order. I need to know how do I go about doing this so that all of the document cannot be change that I have done already. But where the blank spots next to the text can be filled into by the other user and can be sent back to me VIA email. Also I am not using outlook as my email program. -- BRANDON |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a excell document that can be filled out by othe
Thanks this helped out. I can do it this way also. It seems that a few years
ago when I did one with my older version of excel 03' I could leave a highlighted box where the text could be filled in. This might be another option that I could do to the unlocked cells that I am going to have now. Do you have any input on doing this option also? If so that is great you have already been helpful on what I can do so far. Thanks again -- BRANDON "xlmate" wrote: You can protect cells that you doesn't want users to change as follows : Highlight those cells by pressing the Ctl key Go to Format on the Menu bar Select Cells Select Protection tab uncheck the Locked, click OK Go to Tool on the Menu bar Select Protection choose Protect Sheet apply your password Does this do what you want? Pls click Yes if this help cheers, "Phantom Menace" wrote: I have created a work order for my business and now I want to be able to send it to my dealers and have them fill in the underlined blanks on the work order. I need to know how do I go about doing this so that all of the document cannot be change that I have done already. But where the blank spots next to the text can be filled into by the other user and can be sent back to me VIA email. Also I am not using outlook as my email program. -- BRANDON |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a excell document that can be filled out by othe
Thanks for the feedback. Glad I am of assistance.
You could highlight the cells where user can fill in data you want by selecting the cells and click Fillcolor on the Tool bar hope this help. Pls click Yes if this have help you. thanks "Phantom Menace" wrote: Thanks this helped out. I can do it this way also. It seems that a few years ago when I did one with my older version of excel 03' I could leave a highlighted box where the text could be filled in. This might be another option that I could do to the unlocked cells that I am going to have now. Do you have any input on doing this option also? If so that is great you have already been helpful on what I can do so far. Thanks again -- BRANDON "xlmate" wrote: You can protect cells that you doesn't want users to change as follows : Highlight those cells by pressing the Ctl key Go to Format on the Menu bar Select Cells Select Protection tab uncheck the Locked, click OK Go to Tool on the Menu bar Select Protection choose Protect Sheet apply your password Does this do what you want? Pls click Yes if this help cheers, "Phantom Menace" wrote: I have created a work order for my business and now I want to be able to send it to my dealers and have them fill in the underlined blanks on the work order. I need to know how do I go about doing this so that all of the document cannot be change that I have done already. But where the blank spots next to the text can be filled into by the other user and can be sent back to me VIA email. Also I am not using outlook as my email program. -- BRANDON |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a excell document that can be filled out by other pe
Brandon You can send in a, PDF, They cannot change your message but they will
need to answer questions in E Mail Ks Bill "Phantom Menace" wrote: I have created a work order for my business and now I want to be able to send it to my dealers and have them fill in the underlined blanks on the work order. I need to know how do I go about doing this so that all of the document cannot be change that I have done already. But where the blank spots next to the text can be filled into by the other user and can be sent back to me VIA email. Also I am not using outlook as my email program. -- BRANDON |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the use of FILLED GRID button in MS EXcell. | Excel Discussion (Misc queries) | |||
create printable form that has data from excell document insertet | New Users to Excel | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
Excell - How do I "force" cell to be filled or return error mge. | Excel Worksheet Functions | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) |