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.

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.

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.

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.

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.

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.

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.

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.

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.