can I lock a spreadsheet so if any changes are made must be save with new name?

  • Thread starter Thread starter Gord Dibben
  • Start date Start date
G

Gord Dibben

Save it as Read-only or save the original as a Template.

New workbooks will be based upon the Template and the original will not be
altered.

I would go with the second method.

File>Save As>File Type> MS Excel Template(*.xlt)


Gord Dibben MS Excel MVP
 
I'm building a spreadsheet but when I get done I don't want anyone to change
it or fill it with data and then can't use it again later. What's the best
way to do that?

Brad
 
Either do what Gord said or go to

Tools---> Protection ----> Protect Sheet

Then assign a password to. People can look at it but they can not touch
anything or do anything with out the password.
 
Gord,

Thanks for the input. I've done both just to be safe and to have multiple
copies / methods.

Thank You,
Brad
 

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

Similar Threads

How to open a Template under a different name, preferably the dat 1
When you hit Save on a template, how can you save as worksheet? 1
customer billing 2
Excel Template Question 4
getting new workbook name from opened template 1
Excel template and default save name 1
Moving a template from XP to Win 7 1
*.csv format change if .xlt save as .csv in Excel 2007 1

Back
Top