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 clickFormat CellsProtection Tabuncheck
'Locked'
--Press F5From Goto window select 'Special'select 'Formulas'OK will
select all cells with formulas
--Right clickFormat CellsProtection Tabcheck 'Locked'
--Protect sheet from ToolsProtection'Protect Sheet'


If this post helps click Yes
---------------
Jacob Skaria


"Aligahk06" wrote:

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