ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Proctecting certain cells (https://www.excelbanter.com/excel-worksheet-functions/85496-proctecting-certain-cells.html)

Lucille

Proctecting certain cells
 
I want to protect the cells with formulas, but still allow other users to use
the worksheet. Please Help
--
LP051354

Bernard Liengme

Proctecting certain cells
 
You will need to follow this protocol:
1) Select all cell you want users to be able to change; use Format|Cells and
Unlock them in the Protection tab
2)Use Tool|Protection-Protect Worksheet
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lucille" wrote in message
...
I want to protect the cells with formulas, but still allow other users to
use
the worksheet. Please Help
--
LP051354





All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com