Protecting formulas in a workbook

[calimari]

How do you protect cells with formulas in a workbook without keeping changes from being made by other people who are sharing the workbook?

In other words. I have inserted formulas into hundreds of worksheets that are going to be shared. I don't want the calculations to be lost if someone happens to push the wrong keys. Several people will be sharing these worksheets and will need to change numbers in them, but I want to protect the formulas. Is this possible?

Thank you ahead of time.

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[calimari]

Thank you! Very much appreciated.

[calimari]

Is there a way to copy a worksheet and create a hundred more without having to paste them one at a time?

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>

[Anne Troy]

Try this:
http://www.officearticles.com/excel/...soft_excel.htm

You can unlock all your cells. Then hit Edit-->Go to-->Special-->Formulas
and lock those cells. Then protect...

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" <[email protected]> wrote in
message news:[email protected]...
>
> How do you protect cells with formulas in a workbook without keeping
> changes from being made by other people who are sharing the workbook?
>
> In other words. I have inserted formulas into hundreds of worksheets
> that are going to be shared. I don't want the calculations to be lost
> if someone happens to push the wrong keys. Several people will be
> sharing these worksheets and will need to change numbers in them, but I
> want to protect the formulas. Is this possible?
>
> Thank you ahead of time.
>
>
> --
> calimari
>
>
> ------------------------------------------------------------------------
> calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
> View this thread: http://www.excelforum.com/showthread...hreadid=384948
>