| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
can I lock a spreadsheet so if any changes are made must be save with new name?
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. FileSave AsFile Type MS Excel Template(*.xlt) Gord Dibben MS Excel MVP On Tue, 15 May 2007 13:33:46 -0500, "Brad" wrote: 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can I lock a spreadsheet so if any changes are made must be save with new name?
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can I lock a spreadsheet so if any changes are made must be save w
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. "Brad" wrote: 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can I lock a spreadsheet so if any changes are made must be save with new name?
Gord,
Thanks for the input. I've done both just to be safe and to have multiple copies / methods. Thank You, Brad "Gord Dibben" <gorddibbATshawDOTca wrote in message ... 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. FileSave AsFile Type MS Excel Template(*.xlt) Gord Dibben MS Excel MVP On Tue, 15 May 2007 13:33:46 -0500, "Brad" wrote: 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can I lock a spreadsheet so if any changes are made must be save with new name?
Thanks for the feedback Brad
Gord On Wed, 16 May 2007 15:10:41 -0500, "Brad" wrote: Gord, Thanks for the input. I've done both just to be safe and to have multiple copies / methods. Thank You, Brad "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . 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. FileSave AsFile Type MS Excel Template(*.xlt) Gord Dibben MS Excel MVP On Tue, 15 May 2007 13:33:46 -0500, "Brad" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does excel ask to save changes when none have been made? | Excel Discussion (Misc queries) | |||
| save changes when no changes made | Excel Discussion (Misc queries) | |||
| File Save although no changes were made | Excel Discussion (Misc queries) | |||
| Excel2000 keeps asking me to save when no changes were made | Excel Discussion (Misc queries) | |||
| Save prompt when no changes made | Excel Discussion (Misc queries) | |||
Linear Mode
