covering cells

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
 
N

Nick Cranham

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
 
U

Ulf Liljensten

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
 
B

Bob Phillips

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)
 
U

Ulf Liljensten

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
 
N

Nick Cranham

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
 
Top