Identify Named Ranges

[PHMayfield]

You know how excel helps you visualize your named ranges when you zomm to 39% or less? I would like to do that without zooming. I had written code that would select and change the background color for each named range, but what I really want is to not affect the formats. I can create a transparent text box with the name of the range and put it over the range in the "object" layer, but then I can't select the cells underneath by clicking on them. Excel says the object layer always resides above the worksheet layer. So here are my first questions:

1) Can you "trick" excel into putting objects behind the worksheet layer (like a watermark in Word)?

2) If I use the copy and paste as picture feature to create my object, can I place it precisely with some coordinates and can I get coordinate-type information with cells? (I know that if I do this manually by dragging out my object, I can then tell it to move and size with cells, but how do I remove the "manual aspect of this?)

I just wish excel had this feature for any zoom level.

Thanks in advance

Paul

[Corticus]

you should be able to insert an object,
bitmap picture,
and from the image editor make it a "clear" image

corticus

[Corticus]

if that doesn't work,
you could put a big button on the back of the sheet, and through properties make it transparent,
make the button image whatever you want your watermark to be
thats all I can think of,

Corticus

[PHMayfield]

The button doesn't seem to have any properties different than a drawing object for my purposes. I don't think I can put it "behind" the worksheet cells. If there a way to make a button such that you cannot click on it, but rather you end up selecting the cell underneath it instead? (In general, that would defeat the purpose of having a button.)

[Chris Davison]

format
sheet
background

will put an image in the background.

(this won't print though, it's just for display purposes only)

you can add a watermark via the printer settings from the start menu (maybe depending on your printer though)

[PHMayfield]

Thanks for the suggestion, but I really need to be able to put several images into the background. I suppose I could make this one big image from some sheet with my drawing objects on it, but the back ground image doesn't move well (gets out of alignment with ranges) with scrolling, and doesn't scale right when zooming.

Any other ideas?

[PHMayfield]

My apologies for this bump, but I was still hoping to get some help.