Getting rid of selection

  • Thread starter Thread starter Steve Swift
  • Start date Start date
S

Steve Swift

How can I get rid of the selection rectangle? It seems that it's always
there, with a heavy black rectangle, or there's a light black rectangle
marking where it was.

I'm trying to get rid of it altogether, so I can capture an image of the
sheet for use in a webpage.

I can achieve the effect that I want by selecting a cell which is
outside the area that I'm trying to capture, but now that I've found
that I cannot get rid of it entirely, it is driving me nuts trying to do so.
 
You could always select a range not on the visible range, then use the scroll
bars to get back to where you want.
 
How can I get rid of the selection rectangle?

Would this idea work?

Sub Hide_UnHide_Selection()
With ActiveSheet
.EnableSelection = xlNoSelection
.Protect True
End With

'// Then later...
With ActiveSheet
.EnableSelection = xlNoRestrictions
.Protect False
End With
End Sub
 
Oops. Let me fix "Protect"

Sub Hide_UnHide_Selection()
With ActiveSheet
.EnableSelection = xlNoSelection
Application.DisplayScrollBars = False
.Protect Contents:=True
End With

'// Capture Image. Then later...

With ActiveSheet
.EnableSelection = xlNoRestrictions
Application.DisplayScrollBars = True
.Protect Contents:=False
End With
End Sub

--
HTH :>)
Dana DeLouis
Windows XP & Office 2007


<snip>
 
That something of a steep learning curve for someone who's barely got
past opening the application and viewing XLS files generated by someone
else. But thanks for the effort!

I'm settling for clicking one of the cells normally invisible off the
bottom of the window, then saving the file. Fortunately (and
impressively) it remembers the selection next time the file is opened.
That was originally part of the problem - even closing and re-opening
the file did not get rid of the ******* selection box! :-)

However "Thou shalt have something selected in Outlook" was not one of
the commandments that I learned. Must have been in one of the tablets
that Moses dropped on his way down the mountain...
 
Try this. Activate the "Draw Borders" toolbar, and dock it while you
make the screenshot.
Click to expand...

Beware: Excel "virgin" at work.

I found a "Borders" toolbar, and it contained a "Draw Borders" control,
but then I came to "Dock it".

In my parlance that's the act of taking money from someone's wages :-)
 
Steve said:
Beware: Excel "virgin" at work.

I found a "Borders" toolbar, and it contained a "Draw Borders" control,
but then I came to "Dock it".

In my parlance that's the act of taking money from someone's wages :-)
Click to expand...

"Dock it"= grab the little begger by it's title bar and drag it up to
the toolbar are and drop it.
 
Oh, I just use Alt-Printscreen and "crop to taste" ;-) So glad you got
what you needed. You're welcome and have a good weekend!
 
Back
Top