Protecting formula

M

Mickey Mouse

Cell A1= $100
Cell A2= $100
Cell A3= =sum(A1+b1)

How do I protect the formula in A3 from being deleted with the deI or
backspace keys.


Mickey
 
N

Nick Hodge

Mickey

Highlight the cells you want UN-PROTECTING and then go to
Format>Cells...>Protect and un-check the locked box

Now protect the sheet via Tools>Protection...

This will leave the cells you didn't select, locked

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
M

Mickey Mouse

Thanks Nick,
Took a few goes as your solution required (at least for me) slight
modification but I have it now, thankyou.

Mickey
 
D

Danny

Excuse me for butting in her, but I need some help with also. I have a sheet
where when opened, it runs an auto macro to move cell contents from one
column to another and uses a formula to do some calculations. If I select
the columns I want unlocked, then protect the sheet and try to run the
macro, I get an "run time error 1004 unable to set the numberformat property
of the range class" When I debug the following is highlightd
"Selection.NumberFormat = ";;;" " I was a Lotus user and in Lotus I
could select a range of cells or columns to protect, I'm having a hard time
to get Excel to do the same.
I appreciate the help.
Danny
 
D

Dave Peterson

Depending on the version of excel and how you protected the worksheet, the
numberformat propert is also locked.

Sometimes the easiest fix is to have your code unprotect the worksheet, do its
work and then reprotect the worksheet.
 
Top