Perminant Template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Back
Top