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

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
 
B

Brad

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
 
A

AKphidelt

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

Brad

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 do I change default worksheet colour from white? 1
Save box / file name 0
When you hit Save on a template, how can you save as worksheet? 1
How to protect a template but allow all changes to new documents? 2
Can you set up Excel to automatically add a standard footer? 2
getting new workbook name from opened template 1
Few snags in making excel template for statistical analysis 3
I learned how to rename workbook without saving it 16

Top