![]() |
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...
|
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... . |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com