Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Perminant Template
I am creating an order form for a small business on Excel 1997, and I want to save the template so that the cells with 'permanant' information cannot be changed. I have it saved as a template, but the option 'Spreadsheet Solutions' is more what I'm looking for- I only want users to input information with product information, and not be able to change the other settings of the template... Is this possible? Thanks for any help...
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Perminant Template
You could go and unlock the cells other then the ones
containing the data then protect your worksheet with a password. Then resave it as a template, close it and go to explorer and right click on this file then select properties and check the box as read only. This way when users save it it will be saved with their info only and your template will stay blank apart from the info you have provided. Yes. Jeff -----Original Message----- I am creating an order form for a small business on Excel 1997, and I want to save the template so that the cells with 'permanant' information cannot be changed. I have it saved as a template, but the option 'Spreadsheet Solutions' is more what I'm looking for- I only want users to input information with product information, and not be able to change the other settings of the template... Is this possible? Thanks for any help... . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link between a Word template and an Excel template | Excel Discussion (Misc queries) | |||
How do I distribute a template created with Template Wizard ? | Excel Discussion (Misc queries) | |||
NCAA tournament brackets template from Template gallery. | Excel Worksheet Functions | |||
Where do I find a template for a high school template? | Excel Discussion (Misc queries) | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) |