Thread: Worksheet Focus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Worksheet Focus

Off to check IMDB.com.

Nope, I must be wrong <vvbg.

Tom Ogilvy wrote:

It could have been, but Old Yeller really couldn't grab ahold so it seems
less likely. Of couse I was only around 8 back then, so may have missed it
or may have been up getting popcorn during that part. Then again, they tend
to reuse the really good lines.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
You sure it wasn't "Old Yeller"....




Tom Ogilvy wrote:

hmmm, "palliative" eh.

Wasn't it in the Shawshank Redemption where Bubba spoke that immortal
phrase:

"Bend over and grab ahold of them thar screaming bars to palliate your
discomfort"

--
Regards,
Tom Ogilvy

"Norman Jones" wrote in message
...
Hi Paul,

if you set screen updating to false would this acccomplish the same
thing??
No, setting ScreenUpdating to False does not prevent selections and

does
nothing to ensure that the required sheet remains, or becomes the

active
sheet; it merely prevents the screen from being redrawn, thus

rendering
such
selections invisible.

Tom's suggestion was to remove unnecessary selections and represented

a
solution; disabling ScreenUpdating provides a visual palliative to a
concomitant problem of selections, but does nothing to resolve the

OP's
intrinsic problem.


---
Regards,
Norman


"paul" wrote in message
...
if you set screen updating to false would this acccomplish the same
thing??
--
paul
remove nospam for email addy!



"Tom Ogilvy" wrote:

Unless you code moves the focus from this sheet, it will not

change.

Instead of code like

Worksheets("Sheet2").Activate
Range("B9").Select
Selection.copy
Worksheets("Sheet3").Activate
Range("F2").Select
Activesheet.Paste

do colde like

Worksheets("Sheet2").Range("B9").copy _
Destination:=Worksheets("Sheet3").Range("F2")

The point is to avoid selecting. Use references to ranges.

--
Regards,
Tom Ogilvy


"Zani" wrote in message
...
Hello clever people!

I have a project which collects and writes information to various
worksheets
within the file, what I would like to do is keep the focus on the
"front
cover" sheet. The front cover sheet has the links to all the
userforms
etc
to run, but I would like to keep the focus set on this sheet so

it
looks
pretty for the users!

I'm am sure there is an easy way to do this but I can't for the

life
of
me
find it - maybe it's just too late in the day!

--
Zani
(if I have posted here, I really am stuck!)







--

Dave Peterson


--

Dave Peterson