ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   locking formulas (https://www.excelbanter.com/excel-discussion-misc-queries/133980-re-locking-formulas.html)

John

locking formulas
 
You need to change the properties of the cells you want to be able to enter
data into by going to formatprotectionunlocked then protect the sheet
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"hannatrip" wrote:

I try to lock the cells with the formulas in them, i choose lock from cells
than go to the tools,protect sheet and lock it, now i can put any info at all
on the sheet, what am i doing wrong?? help please



All times are GMT +1. The time now is 10:30 AM.

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