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
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
>
Thank you! Very much appreciated.
Is there a way to copy a worksheet and create a hundred more without having to paste them one at a time?
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
>
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
>
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
>
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
>
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
>
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
>
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
>
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
>
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
>
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
>
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks