Hiding cells & keeping them hidden permanently...

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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?

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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