ExcelBanter - Protection

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protection (https://www.excelbanter.com/excel-discussion-misc-queries/77071-protection.html)

ben simpson

Protection

When one applies protection to a worksheet, does it lock any formulas
ex:TODAY() from continuing to update? If not, is there a way other than
disabeling automatic calculating of the sheet, to accomplish this?
Thanks....Ben

Jim Cone

Protection

Ben,

Copy the cell then...
Edit | Paste Special | Values

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"ben simpson"
wrote in message...
When one applies protection to a worksheet, does it lock any formulas
ex:TODAY() from continuing to update? If not, is there a way other than
disabeling automatic calculating of the sheet, to accomplish this?
Thanks....Ben

All times are GMT +1. The time now is 04:42 AM.