I would like to hide a column which contains formulas that I don't want to be
shown. I made the column hidden and protect the sheet in order not ot let
unhide the column. the problem is that if I try to do operations on the other
cell like CTRL + H I get an error message saying that I cannot use the
commend in a protected sheet. As different people are going to use the file I
want to keep the protection but just in the columns with the formulas i have
created. is it possible to protect 2 cloumns only and have the rest of the
sheet able to be modified?
thanks

Hi
Unlock all the cells. Then lock only the columns you want to lock. Then
apply protection. I think the user will still by able to unhide the columns
but they will not be able to make any changes to the locked cells.


"massi" wrote:

> I would like to hide a column which contains formulas that I don't want to be
> shown. I made the column hidden and protect the sheet in order not ot let
> unhide the column. the problem is that if I try to do operations on the other
> cell like CTRL + H I get an error message saying that I cannot use the
> commend in a protected sheet. As different people are going to use the file I
> want to keep the protection but just in the columns with the formulas i have
> created. is it possible to protect 2 cloumns only and have the rest of the
> sheet able to be modified?
> thanks
>

No luck.
I will try to give more info regarding my problem:
column C contain a formula and i want to have hidden.
column O contain links to other spread sheet that need to be updated by
substitute the links.
the other cells contain tex only.
I have tried the method below but it doesn't work.


"Alok" wrote:

> Hi
> Unlock all the cells. Then lock only the columns you want to lock. Then
> apply protection. I think the user will still by able to unhide the columns
> but they will not be able to make any changes to the locked cells.
>
>
> "massi" wrote:
>
> > I would like to hide a column which contains formulas that I don't want to be
> > shown. I made the column hidden and protect the sheet in order not ot let
> > unhide the column. the problem is that if I try to do operations on the other
> > cell like CTRL + H I get an error message saying that I cannot use the
> > commend in a protected sheet. As different people are going to use the file I
> > want to keep the protection but just in the columns with the formulas i have
> > created. is it possible to protect 2 cloumns only and have the rest of the
> > sheet able to be modified?
> > thanks
> >

Select the entire sheet, then Format, Cells, Protection. Untick the boxes.
The select the columns containing your formuals and repeat process but
ticking the protection and hidden boxes.
Then try protecting the spreadsheet.

HTH
Matthew

"massi" wrote:

> No luck.
> I will try to give more info regarding my problem:
> column C contain a formula and i want to have hidden.
> column O contain links to other spread sheet that need to be updated by
> substitute the links.
> the other cells contain tex only.
> I have tried the method below but it doesn't work.
>
>
> "Alok" wrote:
>
> > Hi
> > Unlock all the cells. Then lock only the columns you want to lock. Then
> > apply protection. I think the user will still by able to unhide the columns
> > but they will not be able to make any changes to the locked cells.
> >
> >
> > "massi" wrote:
> >
> > > I would like to hide a column which contains formulas that I don't want to be
> > > shown. I made the column hidden and protect the sheet in order not ot let
> > > unhide the column. the problem is that if I try to do operations on the other
> > > cell like CTRL + H I get an error message saying that I cannot use the
> > > commend in a protected sheet. As different people are going to use the file I
> > > want to keep the protection but just in the columns with the formulas i have
> > > created. is it possible to protect 2 cloumns only and have the rest of the
> > > sheet able to be modified?
> > > thanks
> > >

tried that already but it doesn't work...
any more ideas?

"Matthew Balch" wrote:

> Select the entire sheet, then Format, Cells, Protection. Untick the boxes.
> The select the columns containing your formuals and repeat process but
> ticking the protection and hidden boxes.
> Then try protecting the spreadsheet.
>
> HTH
> Matthew
>
> "massi" wrote:
>
> > No luck.
> > I will try to give more info regarding my problem:
> > column C contain a formula and i want to have hidden.
> > column O contain links to other spread sheet that need to be updated by
> > substitute the links.
> > the other cells contain tex only.
> > I have tried the method below but it doesn't work.
> >
> >
> > "Alok" wrote:
> >
> > > Hi
> > > Unlock all the cells. Then lock only the columns you want to lock. Then
> > > apply protection. I think the user will still by able to unhide the columns
> > > but they will not be able to make any changes to the locked cells.
> > >
> > >
> > > "massi" wrote:
> > >
> > > > I would like to hide a column which contains formulas that I don't want to be
> > > > shown. I made the column hidden and protect the sheet in order not ot let
> > > > unhide the column. the problem is that if I try to do operations on the other
> > > > cell like CTRL + H I get an error message saying that I cannot use the
> > > > commend in a protected sheet. As different people are going to use the file I
> > > > want to keep the protection but just in the columns with the formulas i have
> > > > created. is it possible to protect 2 cloumns only and have the rest of the
> > > > sheet able to be modified?
> > > > thanks
> > > >