Hiding cells & keeping them hidden permanently...
 

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.

Hiding cells & keeping them hidden permanently...
 

This is something you can try:
Hide the rows you want hidden.
Unlock the cells that need to be edited.
Then protect the sheet so that it will not changed.

"Lisa" wrote:

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.

Hiding cells & keeping them hidden permanently...
 

But will this allow myself and others users to be able to change the
worksheet??

"caj" wrote:

This is something you can try:
Hide the rows you want hidden.
Unlock the cells that need to be edited.
Then protect the sheet so that it will not changed.

"Lisa" wrote:

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.

Hiding cells & keeping them hidden permanently...
 

Yes. As long as you unlock all the cells that need to be edited.

"Lisa" wrote:

But will this allow myself and others users to be able to change the
worksheet??

"caj" wrote:

This is something you can try:
Hide the rows you want hidden.
Unlock the cells that need to be edited.
Then protect the sheet so that it will not changed.

"Lisa" wrote:

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.

Hiding cells & keeping them hidden permanently...
 

Okay - so I tried that and yes it did work HOWEVER, I have a column of check
boxes and even though I have that column as unlocked - it reamains protected
and unchangeable when I protect the worksheet. Could it be because the
column that I do have locked and hidden is "linked" to these cells??

It just seems like the hidden column/cells only remain hidden for a certain
time period and then they become unhidden.
Any advice?

"caj" wrote:

Yes. As long as you unlock all the cells that need to be edited.

"Lisa" wrote:

But will this allow myself and others users to be able to change the
worksheet??

"caj" wrote:

This is something you can try:
Hide the rows you want hidden.
Unlock the cells that need to be edited.
Then protect the sheet so that it will not changed.

"Lisa" wrote:

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.

Hiding cells & keeping them hidden permanently...
 

No link the cells should not matter. How did you create the check boxes? or
How are they linked?

"Lisa" wrote:

Okay - so I tried that and yes it did work HOWEVER, I have a column of check
boxes and even though I have that column as unlocked - it reamains protected
and unchangeable when I protect the worksheet. Could it be because the
column that I do have locked and hidden is "linked" to these cells??

It just seems like the hidden column/cells only remain hidden for a certain
time period and then they become unhidden.
Any advice?

"caj" wrote:

Yes. As long as you unlock all the cells that need to be edited.

"Lisa" wrote:

But will this allow myself and others users to be able to change the
worksheet??

"caj" wrote:

This is something you can try:
Hide the rows you want hidden.
Unlock the cells that need to be edited.
Then protect the sheet so that it will not changed.

"Lisa" wrote:

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.

Hiding cells & keeping them hidden permanently...
 

I created the check boxes from the Form toolbar - I just wanted very simple
check boxes to show whether checked or not checked - I don't want the "true"
or "false" values to show up - hence why I am hiding the column. So I've
linked the check boxes to the cells in column beside so that I could hide
that column.

"caj" wrote:

No link the cells should not matter. How did you create the check boxes? or
How are they linked?

"Lisa" wrote:

Okay - so I tried that and yes it did work HOWEVER, I have a column of check
boxes and even though I have that column as unlocked - it reamains protected
and unchangeable when I protect the worksheet. Could it be because the
column that I do have locked and hidden is "linked" to these cells??

It just seems like the hidden column/cells only remain hidden for a certain
time period and then they become unhidden.
Any advice?

"caj" wrote:

Yes. As long as you unlock all the cells that need to be edited.

"Lisa" wrote:

But will this allow myself and others users to be able to change the
worksheet??

"caj" wrote:

This is something you can try:
Hide the rows you want hidden.
Unlock the cells that need to be edited.
Then protect the sheet so that it will not changed.

"Lisa" wrote:

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.

Hiding cells & keeping them hidden permanently...
 

OK. You have to select the check boxes and unlock them also.

"Lisa" wrote:

I created the check boxes from the Form toolbar - I just wanted very simple
check boxes to show whether checked or not checked - I don't want the "true"
or "false" values to show up - hence why I am hiding the column. So I've
linked the check boxes to the cells in column beside so that I could hide
that column.

"caj" wrote:

No link the cells should not matter. How did you create the check boxes? or
How are they linked?

"Lisa" wrote:

Okay - so I tried that and yes it did work HOWEVER, I have a column of check
boxes and even though I have that column as unlocked - it reamains protected
and unchangeable when I protect the worksheet. Could it be because the
column that I do have locked and hidden is "linked" to these cells??

It just seems like the hidden column/cells only remain hidden for a certain
time period and then they become unhidden.
Any advice?

"caj" wrote:

Yes. As long as you unlock all the cells that need to be edited.

"Lisa" wrote:

But will this allow myself and others users to be able to change the
worksheet??

"caj" wrote:

This is something you can try:
Hide the rows you want hidden.
Unlock the cells that need to be edited.
Then protect the sheet so that it will not changed.

"Lisa" wrote:

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.

Hiding cells & keeping them hidden permanently...
 

OF COURSE! That makes totally obvious sense! Sorry for missing that. It
all works now! Thank you very much for your help!

"caj" wrote:

OK. You have to select the check boxes and unlock them also.

"Lisa" wrote:

I created the check boxes from the Form toolbar - I just wanted very simple
check boxes to show whether checked or not checked - I don't want the "true"
or "false" values to show up - hence why I am hiding the column. So I've
linked the check boxes to the cells in column beside so that I could hide
that column.

"caj" wrote:

No link the cells should not matter. How did you create the check boxes? or
How are they linked?

"Lisa" wrote:

Okay - so I tried that and yes it did work HOWEVER, I have a column of check
boxes and even though I have that column as unlocked - it reamains protected
and unchangeable when I protect the worksheet. Could it be because the
column that I do have locked and hidden is "linked" to these cells??

It just seems like the hidden column/cells only remain hidden for a certain
time period and then they become unhidden.
Any advice?

"caj" wrote:

Yes. As long as you unlock all the cells that need to be edited.

"Lisa" wrote:

But will this allow myself and others users to be able to change the
worksheet??

"caj" wrote:

This is something you can try:
Hide the rows you want hidden.
Unlock the cells that need to be edited.
Then protect the sheet so that it will not changed.

"Lisa" wrote:

Very simple question: I have a "shared" workbook that contains many hidden
rows. For a few days, those rows remained hidden, but for some reason the
sheet is now loading with those rows now visible and I don't understand why.
Please help. I just want these to be hidden pretty much forever. Thanks in
advance.