PROTECTION

  • Thread starter Thread starter Aligahk06
  • Start date Start date
A

Aligahk06

Dear All,

I have a workbook with Hasformula . This formula is located in Different
Cell ( Unordered manner).
I want to protect all the cell that contains HasFormula and remaining cell
for edit.

Can i do this ?

Please assist?

Rgds,
Aligahk06
 
--Select all cells (Ctrl+A). Right click>Format Cells>Protection Tab>uncheck
'Locked'
--Press F5>From Goto window select 'Special'>select 'Formulas'>OK will
select all cells with formulas
--Right click>Format Cells>Protection Tab>check 'Locked'
--Protect sheet from Tools>Protection>'Protect Sheet'


If this post helps click Yes
 
Back
Top