Glad to help. I don't know how to make that window you are looking
for, it looks like Excel hides rows & columns differently depending on
what you are trying to do.

Depending on how you hid the cells, it would either be
FormatRowUnhide or FormatColumnUnhide.

HTH,
JP


On Jan 8, 7:47*am, Cooz wrote:

I would like to have a "window" of cells surrounded on all four sides by
gray areas, say for example that the range B3:D7 is visible, and that the
rest of the worksheet is gray. Do you - or does anyone- know how to do this?

Other question: how do I turn a gray area back into "visible and accessible"
(other than pressing Ctrl-Z immediately after creating a gray area)?

Thank you,

Cooz



"JP" wrote:
Click ToolsOptionsView tab, uncheck "Row & Column headers"

If you select all cells (Ctrl-A) right-click and choose "Hide" you
will get the gray condition you are looking for.

HTH,
JP