Getting rid of selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Swift - 25 Apr 2007 18:54 GMT

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.

Signature

Steve Swift
http://www.swiftys.org.uk/swifty.html
http://www.ringers.org.uk

Reply to this Message

Dave Peterson - 25 Apr 2007 19:36 GMT

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? It seems that it's always
> there, with a heavy black rectangle, or there's a light black rectangle
[quoted text clipped - 11 lines]
> http://www.swiftys.org.uk/swifty.html
> http://www.ringers.org.uk

Signature

Dave Peterson

Reply to this Message

Dana DeLouis - 25 Apr 2007 22:26 GMT

>> 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

Signature

HTH :>)
Dana DeLouis
Windows XP & Office 2007

> You could always select a range not on the visible range, then use the
> scroll
[quoted text clipped - 16 lines]
>> http://www.swiftys.org.uk/swifty.html
>> http://www.ringers.org.uk

Reply to this Message

Dana DeLouis - 25 Apr 2007 22:44 GMT

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

Signature

HTH :>)
Dana DeLouis
Windows XP & Office 2007

>>> How can I get rid of the selection rectangle?

<snip>

Reply to this Message

Steve Swift - 26 Apr 2007 09:53 GMT

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...

Signature

Steve Swift
http://www.swiftys.org.uk/swifty.html
http://www.ringers.org.uk

Reply to this Message

Bob I - 26 Apr 2007 13:18 GMT

Try this. Activate the "Draw Borders" toolbar, and dock it while you
make the screenshot.

> That something of a steep learning curve for someone who's barely got
> past opening the application and viewing XLS files generated by someone
[quoted text clipped - 9 lines]
> the commandments that I learned. Must have been in one of the tablets
> that Moses dropped on his way down the mountain...

Reply to this Message

Steve Swift - 26 Apr 2007 16:41 GMT

> Try this. Activate the "Draw Borders" toolbar, and dock it while you
> make the screenshot.

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 :-)

Signature

Steve Swift
http://www.swiftys.org.uk/swifty.html
http://www.ringers.org.uk

Reply to this Message

Bob I - 26 Apr 2007 18:59 GMT

>> Try this. Activate the "Draw Borders" toolbar, and dock it while you
>> make the screenshot.
[quoted text clipped - 5 lines]
>
> In my parlance that's the act of taking money from someone's wages :-)

"Dock it"= grab the little begger by it's title bar and drag it up to
the toolbar are and drop it.

Reply to this Message