Hiding Formulas in Formula bar
 

I am facing a unique problem in hiding the cells that have formulas.
I have w/book in which 5 cells(K2:K6) of every sheet has formulas.Range(a2:A6)
in every sheet is database range which I am Updating with the help of
Userform.
I have hidden all the formula cells in every sheet so that nobody edits or
change the formulas. When I am using the userform ,an error message is
triggering
that 'a cell or object which I am changing is read only'.
where I did wrong in hiding formulas?.What I did in hiding formulas is
Selected the cells containing formulasformat CellsprotectionChecked
Hidden optionok.Next from Tools MenuProtectionProtect sheetProtect
w/sheet and contents of locked cellallow users to select locked
cells&select unlocked cellsok

Hiding Formulas in Formula bar
 

Unhide the before working on them, then reset them to hidden after.

--
__________________________________
HTH

Bob

"TUNGANA KURMA RAJU" wrote in
message ...
I am facing a unique problem in hiding the cells that have formulas.
I have w/book in which 5 cells(K2:K6) of every sheet has
formulas.Range(a2:A6)
in every sheet is database range which I am Updating with the help of
Userform.
I have hidden all the formula cells in every sheet so that nobody edits or
change the formulas. When I am using the userform ,an error message is
triggering
that 'a cell or object which I am changing is read only'.
where I did wrong in hiding formulas?.What I did in hiding formulas is
Selected the cells containing formulasformat CellsprotectionChecked
Hidden optionok.Next from Tools MenuProtectionProtect sheetProtect
w/sheet and contents of locked cellallow users to select locked
cells&select unlocked cellsok

Hiding Formulas in Formula bar
 

This w/book project I made,will be given to a user who will not given access
to access formulas,any minute change will lead to financial scam.
is there any solution?
"Bob Phillips" wrote:

Unhide the before working on them, then reset them to hidden after.

--
__________________________________
HTH

Bob

"TUNGANA KURMA RAJU" wrote in
message ...
I am facing a unique problem in hiding the cells that have formulas.
I have w/book in which 5 cells(K2:K6) of every sheet has
formulas.Range(a2:A6)
in every sheet is database range which I am Updating with the help of
Userform.
I have hidden all the formula cells in every sheet so that nobody edits or
change the formulas. When I am using the userform ,an error message is
triggering
that 'a cell or object which I am changing is read only'.
where I did wrong in hiding formulas?.What I did in hiding formulas is
Selected the cells containing formulasformat CellsprotectionChecked
Hidden optionok.Next from Tools MenuProtectionProtect sheetProtect
w/sheet and contents of locked cellallow users to select locked
cells&select unlocked cellsok

Hiding Formulas in Formula bar
 

Sub yourmacro()
ActiveSheet.Unprotect Password:="pword"

do your stuff code

ActiveSheet.Protect Password:="pword"
End Sub


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 10:55:01 -0700, TUNGANA KURMA RAJU
wrote:

This w/book project I made,will be given to a user who will not given access
to access formulas,any minute change will lead to financial scam.
is there any solution?
"Bob Phillips" wrote:

Unhide the before working on them, then reset them to hidden after.

--
__________________________________
HTH

Bob

"TUNGANA KURMA RAJU" wrote in
message ...
I am facing a unique problem in hiding the cells that have formulas.
I have w/book in which 5 cells(K2:K6) of every sheet has
formulas.Range(a2:A6)
in every sheet is database range which I am Updating with the help of
Userform.
I have hidden all the formula cells in every sheet so that nobody edits or
change the formulas. When I am using the userform ,an error message is
triggering
that 'a cell or object which I am changing is read only'.
where I did wrong in hiding formulas?.What I did in hiding formulas is
Selected the cells containing formulasformat CellsprotectionChecked
Hidden optionok.Next from Tools MenuProtectionProtect sheetProtect
w/sheet and contents of locked cellallow users to select locked
cells&select unlocked cellsok