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

"Ulf Liljensten" wrote in message
nk.net...
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

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


Nick Cranham wrote:

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

"Ulf Liljensten" wrote in message
nk.net...

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,

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)

"Ulf Liljensten" wrote in message
nk.net...
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


Nick Cranham wrote:

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

"Ulf Liljensten" wrote in message
nk.net...

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

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

Bob Phillips wrote:

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.

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

"Ulf Liljensten" wrote in message
nk.net...
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

Bob Phillips wrote:

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.