covering cells

  • Thread starter Thread starter Ulf Liljensten
  • Start date Start date
U

Ulf Liljensten

I need to hide (or more correctly: cover) cells in a worksheet without
impacting the position of any other elements in the worksheet.

Anybody knows what the best way to do this is?

thanks,

Ulf
 
Ulf,
By "other elements" you mean buttons, images etc ?
If so, these have options to move and/or size with cells, in the Format >
Properties.

Also you tell where OLEObjects are by their .TopLeftCell and
BottomRightCells. These properties are read-only though.

NickHK
 
Nick,

I primarily mean other cells. I want to hide some cells but keep other
cells in the same column or row visible, and I don't want anything on
the worksheet to change position.

Any ideas?

thanks,

Ulf
 
Ulf,

Could you just change their font colour to white? It is still possible to
see the values (select a block), but in normal circumstances, it is clear.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob,

I can - but I have a lot of custom information (border color, bg color,
fg color) and would prefer not to have the program remembering which
cells have what values when I turn them visible again.

Ulf
 
Ulf,
What about if you kept the formatting info in some suitable structure in
that cell's Comment. You could hide the Comments under the Options menu, so
they would not show (No Comments would show, if that is relevant ?).
To show the cell in all its glory, have a function that reads that cell's
comment and replaces the formatting.

NickHK
 
Back
Top