Name>Define shows in sheet

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

How do I get rid of the name defined for a range and which shows in the
sheet? It does not print but it cloggs the view of what is underneath.
Tx,
Pierre
 
Pierre -

These don't show up unless your zoom is below 40%. That's pretty small,
isn't it? I don't think you can turn these labels off.

- Jon
 
Jon,
Good morning,
These are for the topo maps for which you gave me help. The reason why I am
below 50% is that I want the complete selection to be within the screen so
that I can printscreen into a picture for photoediting and mapping a trek.
The source data is usually 240X by120Y or vice versa (a trek of ca. 150
miles with comfort on each end) , which at 300pixels per inch will not give
much of a large picture! Or if printed in 4*6 inch photo will show pretty
large squares. The source data is very rough with one elevation point every
30" of arc (1/2 nautical mile).

Well, I did not want to post without trying another trick: I just deleted
the name of the range (Insert, Name, Delete) before printscreen,"et voilà",
the label was dropped. It would disallow running the Private that
JEMcGimpsey gave, but after printscreen I closed without saving, and your
Sub did not require a RangeName.
There is always a way.
Tx,
Pierre
 
Back
Top